Read CSV file into sqlite3 on the iPhone

Question

Is there a way to read a CSV file into sqlite3 on the iPhone? Is there sqlite3 functionality similar to the SQL commands

LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE TABLENAME FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';

Or is there an approach that converts the CSV file into a format that sqlite3 can read automatically which the iPhone brings up the application?

Answer 1

You can read CSV and other files into your DB using Core Data but I dont think that is going to help you as it sounds like you have started developing using Sqlite

Answer 2

Hi, you can try the firefox addon "SQLITE MANAGER" wich has an option to import data from CSV.

SQLITE Manager for FireFox