Running Excel Replace Function from Access

michael1p

New member
Local time
Today, 15:08
Joined
Jun 18, 2007
Messages
7
Hi all

Im trying to set up an access module to run a find and Replace on a CSV file to remove all speech marks from it.
Does anyone know how I would go about doing this?

Cheers for any help you can offer

Michael
 
What do you mean by "speech marks"? Could you please provide a sample?
 
There are a couple of " in the CSV file which I would like to remove.
 
Ahh. For future reference, they are called quotation-marks, or, in technical context, double-quotes. Also, removing them from a CSV file is not always a good idea, because many programs that read CSV files use double-quotes as text-qualifiers. (Text-qualifier: a character that is used to identify both the beginning and the end of a text entry).

Can you give us more background on what you are attempting to accomplish, the application environment, and some sample-data, so that we may better advise you as to the best method of dealing with the double-quotes?
 

Users who are viewing this thread

Back
Top Bottom