autofind and remove text + macro

D

Darren

I have a problem with an access database. The data is imported from a csv
file (Comma Separated Value) conseuently the database contains this sign " .
I want to remove all the " everytime I open the database automatically. how
can I do it? Any help?
 
D

Dennis

The import wizard or saved specification script for the import allows you to
specify that text strings are surrounded by "
When it imports it will then remove the "
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top