Access Export File Transfer - Help Required

[sankararam]

Hi

I am trying to export a file from access and I have given this command
DoCmd.TransferText acExportFixed, , "Orders", "C:\MyFiles\Export\cc.txt", True

and I tried all the possibilities. The command executes successfully but, I did not find the file cc.txt - I tested through query and my table has records. My only problem is that it is not writing the file into the folder or anywhere else.

Any help is appreciated and my advance thanks

Thanks,
Sankara

 

[KWells]

For acExportFixed you need an ini file or a specification file: "For a fixed-width text file, you must either specify an argument [specification file name] or use a schema.ini file...". That is from VBA help.

You likely have Warnings off, or you would get error number 2511 from Access indicating the need for a spec file.