Removing Quotes when importing CSV files

  • Thread starter Thread starter Centaur
  • Start date Start date
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
 
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 """")
 
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
--------------------
 
Back
Top