Hello everyone,
I had a small doubt regarding importing CSV files into SQLite. I have
this simple text file with a couple of columns and a few records. Its a comma
separated file.
When i try importing it into a SQLite table, i get some errors like "expected 2
columns of data but found 1". Later i found that importing a comma separated
file into SQlite wont work because a comma is considered as a delimiter by the
the SQLite engine even within a "". Is this true? My csv file source is a
webservice, so i have to try adjusting with the comma delimiter. They are not
gonna change it for me :). Should i write some simple string parser of my own?
Or is there any better, optimal method?
Thx in advance
Mithun Nair | Software Engineer| Endeavour Software Technologies |
Tel: +91 80 4288 5544 | +1 214 306 6848, 214 295 7245 (US) | +44 20 7193 0986
(UK) | Mob: +9886808265 |
THE MOBILITY COMPANY | www.techendeavour.com
Endeavour Software Technologies Pvt. Ltd. is a registered company in India
under the Companies Act.
Endeavour Software Technologies (UK) Ltd. is a limited company registered in
England & Wales.
Endeavour Software Technologies Inc. is incorporated in the State of Texas, US
The recipient acknowledges that Endeavour Software Technologies and associated
companies (collectively "Endeavour"), are unable to exercise control or ensure
or guarantee the integrity of/over the contents of the information contained in
e-mail transmissions and further acknowledges that any views expressed in this
message are those of the individual sender and no binding nature of the message
shall be implied or assumed unless the sender does so expressly with due
authority of Endeavour. Any unauthorized review, use, disclosure,
dissemination, forwarding, printing or copying of this email is strictly
prohibited and may be unlawful
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
