Import Text File Error with quotes being stripped

[examart]

Hi,



I Need Some help, I want to import file from txt file, but I Have Some problem with one record because some double qoute in one column, please help me ho to fix it:

sample :

Name	Customer
GEDE	Surya
Budi	Bintang
juni	PIE SiSU "OLIVE"

in last record costumer name with qoute, and make error when import it,

thanks in advance

eka

[June7]

The import wizard has no problem with the quotes. Show the code you are using for the import. Is that the exact structure of the text file? Or does that example show the data transposed?

[rpeare]

You can also prior to attempting an import, run a search and replace function on the text file (you can do this from access or just by opening a text editor assuming there are no other instances where you want to retain the "" marks)