Remove Quote Marks

[Leesha]

Hi,

I have csv file that I imported into the Access. It imports each column however the problem is that each piece of date is preceeded and ended with " ". For example "John"
would be how the first name is imported when I need it as John. The number of characters per cell will always vary. Is it possible in a query to remove the ""?
Thanks,
Leesha

[HansV]

When you import a text file into Access, you can specify whether the " acts as text qualifier:

noqualifier.png

withtextqualifier.png

After the fact, you can correct it by replacing " with nothing in the Replace dialog, or by using something like

NoQuotes: Replace([FieldName], """", "")

in a query.

[Leesha]

Awesome! Thanks Hans!

Leesha