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