remove quote marks from csv file

[ronwmon]

I need to import a csv file into an Access database. The problem is the csv file has quotes on each side of the elements. For example:

"Element1","Element2","Element3"

I need to delete the quotes prior to the import. I want to do this with visual basic .net (Visual Studio 2013).

Any help is appreciated.

Ron--

 

[fredericofonseca]

How are you importing the file?

Several of the methods to import a file into access will have a option to say if the columns have a text qualifier and if this is set to quotes it will remove them.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886