sqlite load data infile Syntax Error

Question

I'm working on importing a very large CSV file into SQLite. My understanding is that LOAD DATA INFILE is my best bet. I've created a table for it to reside in, and am attempting to execute the following query

LOAD DATA LOCAL INFILE 'F:/Downloads/NielsonReport.csv' 
INTO TABLE neilson;
IGNORE 1 LINES

but, I get the following error:

Error while executing SQL query on database 'test': near "LOAD": syntax error

I seem to be getting an error along these lines regardless of what I'm trying to execute.

I feel like I'm missing something very basic, and would appreciate any help resolving this problem (I've been referencing this page for information so far)

No change when doing that. I've tried a few permuations in case i was properly or improperly using semicolons to mark off items. — Jordan Lovell, Jun 16 '17 at 21:48
Question...are you trying to load the csv file into `sqlite` or `mysql`? — Hackerman, Jun 16 '17 at 21:52
https://stackoverflow.com/questions/697004/bulk-load-data-into-sqlite — Hackerman, Jun 16 '17 at 22:05

score 1 · Answer 1 · answered Jun 17 '17 at 08:02

1

When you are using SQLite, it would be a good idea to reference the SQLite documentation instead.

Anyway, SQLite itself does not have a CSV import function. But the sqlite3 command-line shell allows to import CSV files with the .import command.

answered Jun 17 '17 at 08:02

CL.

173,858
17
217
259

score -1 · Answer 2 · answered May 20 '19 at 10:09

-1

Use import command like this.

.import '/Users/haseeb/Desktop/names_data.txt' Names

answered May 20 '19 at 10:09

Haseeb Mir

928
1
13
22

sqlite load data infile Syntax Error

2 Answers2