Search results

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...

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.:confused:

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

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.

Nope. Thanks again.:)

I am using access 2007, however the database still 2003. (.mdb)

Thank you so much for your code. it worked like a charm :o.

Thanks Dave, I'll try your code. so there isn't anything in docmd.transfertext??

are you saying the double quotes can't be removed from the field?? if I export from ms-access directly to csv file, I can choose text delimiter to none. so, I think there is a code in docmd.transfertext to exclude those double quotes. I am not sure about the other application. but the things is...

yes, import to other application.

Yes, I am trying to export to csv file that doesn't have the double qoutes.

after I exported and save the spec name, how do I use it :confused:. I use docmd.transfertext "specname","TableA","Myfile.csv" but it didn't do anything at all :(. and I want to export without the string at all.

Hi, Can some body help me please. I am trying to export from access table to csv file using docmd.transfertext acexportdelim,,"TableA","myfile.csv" how ever it came with the double quoute in between the field ("firstname","lastname"). I need the format without the double quote...