Removing Quotes when importing CSV files

[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

 

[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 """")

 

[Centaur]

Many Thanks that works just fine

Have a great day

Centaur

 

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