Importing csv files

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.
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access importing a text file with quotes 4
export database to a text file 1
Differences Between Two Spreadsheets ? 1
How to keep loaded file's format intact? 1
Format of CSV file not preserved when edited in Excel 2007 1
Changing commas in .csv to quotation marks 1
import csv truncation 1
Excel CSV Files; Creating Of 3

Top