Forums

How to upload csv into a blank table in my database

I've built an RSS feed scraper that runs locally on my machine. It is currently stored as csv file.

I'd like to upload it to an existing table in my database.

scp -P 8022 /Users/davidelks/Dropbox/Personal/national_news_scrape_classy.csv elksie5000@ssh.pythonanywhere.com :/home/elksie5000/

Tried that:

ssh: connect to host ssh.pythonanywhere.com port 8022: Connection refused lost connection

How do I fix it?

The ssh port is 22

08:50 ~$ scp -P 22 /Users/davidelks/Dropbox/Personal/national_news_scrape_classy.csv elksie5000@ssh.pythonanywhere.com : /home/elksie5000/
:/home/elksie5000/: No such file or directory

Do you have a spaces in elksie5000@ssh.pythonanywhere.com : /home/elksie5000/ ?

Sorry just to be clear, there shouldnt be spaces