export table as delimited text

[captnk]

I am having a problem getting the syntax of this right,can someone pls help
my syntax is:

DoCmd.TransferText acExportDelim, , "Tablename", "d:\directorya\directory2\directory3\" & filename, no


Filename is derived from a table field,and it does show up the correct table name.
I need file as a variable so that I do not end up with duplicate files

Tks

 

[Dgar007]

Try this:

DoCmd.TransferText acExportDelim, "EXPORT SPEC", "TABLENAME", "FULLPATH" & VARIABLE & ".txt", False, ""

 

[captnk]

Many tks Dgar...It works fine now
Captnk