Import Text file with " in the field

WineSnob

Not Bright but TENACIOUS
Local time
Today, 09:05
Joined
Aug 9, 2010
Messages
211
I am importing a text file into a table in Access 07. SOME of the data has " in front and back and some of the data does not. How can I get rid of the " marks?
Example;
"BOSCH, HARRY"
XTRA CARS
I have imported the entire field into a temp table. Now I want to append to a Master table to look like.
BOSCH, HARRY
XTRA CARS
 

Users who are viewing this thread

Back
Top Bottom