wrong sintax in tranfer text (vba)

[Guest]

i
try to transfer text out of my database with the line of code:

DoCmd.TransferText acExportFixed, [FopTransferScanvaegt Export
Specification], FopTransferScanvaegt, fop.txt, no

but something is wrong with the sintax... can someone tell me what is it??

thanks in advance

 

[tina]

try

DoCmd.TransferText acExportFixed, _
"FopTransferScanvaegt Export Specification", _
"FopTransferScanvaegt", "fop.txt", False

see the TransferText Method topic in Access VBA Help for more information.

hth