Text Qualifier

[lwibisana]

Have you tried using an Import/Export specification like I suggested? You need to use a specification that will allow you to set the "None" your talking about.

By not using a specification access uses its default settings.

I set to "None" but don't know how to use it in vbcode.
when I used docmd.transfertext, "c:\specfication.ini", "table", "mytext.csv" it didn't do anything at all.

 

[namliam]

See my post #2 in this thread, you need to craete a specification in the database... I am sure a config file like that works too... but I have found that to be buggy and unreliable in the past.

If you use the specification, you do it using the gui inside access.... should not lead you into problems.

 

[lwibisana]

See my post #2 in this thread, you need to craete a specification in the database... I am sure a config file like that works too... but I have found that to be buggy and unreliable in the past.

If you use the specification, you do it using the gui inside access.... should not lead you into problems.

I did use gui inside access with no problem. my question is how do I code in vb-access with the command "docmd.transfertext".

 

[namliam]

Did you use the gui "Save specification" ??

From the access help:
docmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

So you insert your saved specification into the Second parameter...

 

[lwibisana]

Did you use the gui "Save specification" ??

From the access help:
docmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

So you insert your saved specification into the Second parameter...

I did insert the specification into the second parameter.
docmd.TransferText acExportDelim, "SpecName", "SourceTbl", "DstCsv"
but nothing happened. it didn't give me any message.

 

[namliam]

You should already have setup the spec in the GUI, what message should it give you?

 

[lwibisana]

You should already have setup the spec in the GUI, what message should it give you?

Yes, I did setup the spec in GUI. and when run the command below, it did not transfer to a text file.
docmd.TransferText acExportDelim, "SpecName", "SourceTbl", "DstCsv"
I hope I make myself clear. the problem is the command docmd.transfertext
doesn't do anything at all. the GUI part was done perfect.

 

[namliam]

Only reason I can think of it not working is you didnt correctly make the specification.

FOr import use: File > Get external data > Import
For export: File > Export