Import Excel CSV into Sqlite3

Asked Mar 16 '13 at 01:15

Active Mar 16 '13 at 05:02

Viewed 473 times

I have a long CSV file (exported from excel) that looks like this:

Architecture (ARCH),201,Basic Drawing,  9-12PM,   3
Architecture (ARCH),202,Graphic Commun, 9-12PM,   3
Architecture (ARCH),211,Digital Drawing,130-230PM,3
Architecture (ARCH),212,Understand Arch,10-11AM,  3

When I try to import it through the SQLite3 shell, it only takes the first line. How can I fix this?

edited Mar 16 '13 at 05:02

NickSlash

4,758
3
21
38

asked Mar 16 '13 at 01:15

Astephen2

1

Can you edit your post to include the commands you issued to the shell? – NickSlash Mar 16 '13 at 05:02
Maybe [this answer](http://stackoverflow.com/a/1045961/1380680) helps? – Reinier Torenbeek Mar 16 '13 at 15:01
The commands were: create table classes(... .separator ',' .import classes.csv classes – Astephen2 Mar 16 '13 at 21:26

Import Excel CSV into Sqlite3

0 Answers0