Importing csv files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing a csv file and when I open the new table, all of the values
are enclosed in quotation marks. How can I remove the quotation marks? Or,
how can I get my query to work because right now I can't filter it.
 
Hi Kristin,

Possible causes:

1) when importing the file, you have not specified the quotation mark
as the "text qualifier". In that case the quotation marks will be
imported.

2) the "quotation marks" in the file are not standard quotation marks.
Normal CSV files use the ASCII quotation mark, Chr(34). If your file
has (for example) "curly quotes" as used by Word, I don't think Access
will recognise them.
 
Back
Top