Access Export

[Stella]

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

DoCmd.TransferT ext([TransferType As AcTextTransferT ype = acExportDelim],["exportraw"],[strTable],[FileName],[True],[ ],[ ])

Any ideas?

[wlc04]

Do you have an export specification built?

[safak112]

wlc04 can you please clarify that?

[wlc04]

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.