How to delete a specific character from all records in table

[jahlmer]

Access 2002/XP

I'm needing to import data from a .csv file that uses " to separate text from tab. However there is one field that is text and contains " as part of a description field that I can't skip. When trying to import using the " as text delimiter, the fields get off track on some of the records.

So I'm thinking I should import without using " as text delimiter and allow them to exist for the import. But, they have to go, even if it's the ones in the description.

The question is How can I delete " from all fields in the table after the data has been imported?

 

[PHV]

Take a look at the Replace function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244