importing .csv files into SQlite through objective C

Question

I am able to import .csv files into a SQlite table through the command line. It works nice and fine. What i wanted to know was is it possible to do the exact same thing through Objective C code..meaning execute commands like .mode csv && .import file.csv table.

The interface sqlite3 does all normal SQL statement execution like selecting, deleting etc..But i am not sure about the importing part.

Any guidance anyone? Thanks in advance Regards

Community · Accepted Answer · 2017-05-23 11:48:27Z

2

You can try the virtual table described on the ImportingFiles page. However, you may best off just using an existing Objective-C CSV parser, then inserting each row yourself (within a transaction). See Anyone know of a good csv to NSArray parser for objective-c for a start.

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Sep 14, 2010 at 4:42

Matthew Flaschen

286k53 gold badges523 silver badges554 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mithun Nair Over a year ago

Thanks for your response guys. Actually, i came across a few parsers(and efficient ones too), but my feeling was if there was support in SQLite itself, i should be using it. Thats why i wanted to go with the import rather than try parsing myself or use a wrapper. Anyways I'm trying it with the virtual table features. Thanks again

Ramani Hitesh Over a year ago

how to direct import csv file to sqlite database objective c

Collectives™ on Stack Overflow

importing .csv files into SQlite through objective C

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related