importing CSV file into sqlite table

Question

I've imported a CSV file into an sqlite table. everything went fine except it included quotes " " around the data in the fields. not sure why because there are no quotes in the CSV file.

anyone know how to avoid this or get rid of the quotes somehow?

Here's a screenshot from the firefox sqlite import settings I'm using:

alt text

thanks for any help.

Have you tried to select "Double quotes ("), if necessary (Standard)" under "Fields enclosed by"? — Michael Banzon
– Michael Banzon, Commented Sep 24, 2010 at 10:14
that worked. I had tried that before but I needed to empty the table before it overwrote the existing data. worked great. thanks! — hanumanDev
– hanumanDev, Commented Sep 24, 2010 at 10:39

user158017 · Accepted Answer · 2010-09-24 13:05:18Z

3

I would guess that there really ARE double-quotes around the data. If you use Windows, a CSV will automatically open in Excel and it looks like there are no quotes because Excel interprets the file properly. However, I bet if you open the file in Notepad there will be quotes around the strings.

and then, as pointed out in your discussion above, truncate your sqlite table and reimport the data, indicating that the fields are enclosed by double quotes.

answered Sep 24, 2010 at 13:05

user158017

3,0011 gold badge31 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

importing CSV file into sqlite table

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related