TransferText Text Qualifier Problem

[GooGoocluster]

I am trying to import many csv's files that a client has entered (so I cant change them now)

I have a problem with the text qualifier, I need it to ingnore the field delimiter which is a , in this case.

there are some people who have their address like this:

"123 s 456 e,#38","name","LastName"

even though the , is inside the text qualifier it still cuases import errors. Is there a way around this with out changing the delimiter??

Thanks in Advance

 

[alvechurchdata]

Just tried this with your example and got three fields in the result table called "test":
[TT]
123 s 456 e,#38
name
LastName
[/TT]

Is this what you're seeing?

I used

docmd.TransferText acImportDelim,,"test","e:\csv.txt"

where csv.txt held "123 s 456 e,#38","name","LastName"

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[GooGoocluster]

whats happening is #38 is shifted into the next field and throwing off the rest of that row. so All of the text in that row are in the wrong field, i.e. name is under lastName field and so forth.