trouble with importing csv file with two delimiters

[hlmnsbuggy]

good afternoon

I have a .csv file that was sent to us by an outside entity. I'm trying to import, but with problems. There are two delimiters (~ and ,) to separate the fields as below

~01~,~TX~,~2~,~23~,~23~,~000~,

import wizard only have one selection,How shall I import the csv to access. Please help

Ann

 

[Remou]

From your example, it seems to me that ~ (tilde) can be used for the text qualifier, if you can accept all fields being imported as text. Alternatively, you can use the Open statement to read text files.

 

[hlmnsbuggy]

thank Remou for your quick reply, but if I use ~ as text qualifier, I don't see this option in Access import wizard, only " ' {none}, what shall I do?

 

[hlmnsbuggy]

I got it, I just type ~ in, that solve the problem,

Thank you