What do you do with extra quotes when importing a csv file?

[Guest]

We receive a parsed csv file that I import into a access table. I have 2
records that won't import because that parsed file has a field with extra
quotes, like some of the words in a field have quotes around them. If you
open it in excel, it works fine, you just lose the quotes. But access just
throws those records into an error table.

I have no clue as to how to get around this. Any advice would be truly
appreciated.
Thanks

 

[John Nurick]

In a CSV file where text fields are "qualified" with quotes, Access expects
any quotes in the data to be doubled. E.g. the data value
Joe "Legs" Wilson
appears in the file as
... ,"Joe ""Legs"" Wilson", ...

I'm not sure from your description just what's in your file, but if it
imports satisfactorily into Excel the simplest thing is probably either

1) import into Excel, save the Excel file, and then import the data into
Access from there.

2) if there are problems with (1), then import into Excel, use Save As to
save the data in a new CSV file - hopefully with the quotes handled better -
and then import the new CSV file into Access.

 

[Guest]

That works. Thanks. Excel doesn't seem to care about that extra quote in
there. It separated the fields correctly.
Thank you.....