Access Export

Am geeting compile error: Expected: = on the following code:

DoCmd.TransferText([TransferType As AcTextTransferType = acExportDelim],["exportraw"],[strTable],[FileName],[True],[ ],[ ])

Any ideas?

re: Access Export

Do you have an export specification built?

re: Access Export

wlc04 can you please clarify that?

re: Access Export

If you manually export the data to a text file you are prompted for several parameters.
When you reach the last parameter (you will specify the export path) choose the Advanced button and then choose Save As and it will give you a default specification name (you can rename whatever you want). This specification is saved and can be used in macros and modules so that access knows how you want the file to look when it's exported.