Removing Quotes when importing CSV files

C

Centaur

Hi

Can anyone tell me please the best way to remove the quotes in certain
fields when importing CSV files as access tables.

Many thanks and best wishes

Centaure
 
D

Douglas J. Steele

You can run an Update query using Replace to remove the quotes:

UPDATE MyTable SET MyField = Replace(MyField, Chr(34), "")

(Chr(34) is the representation for ": you could also use """")
 
K

Kailash Kalyani

A simple option could be to prepare the CSV file by a simple find and
replace. Alternately you could run code after the import to strip it using
VBA string functions like left, mid and right

Kailash Kalyani
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC
--------------------
 
Top