Exporting an access table

[csk003]

Is there a way to export access table to a tab delimited text file using a button? And the text file name should
have a text(fixed) and time stamp of the export?
(I am pretty new to VBA)

 

[Remou]

A search produced this:
Access Export Format
thread705-812615

 

[SeeThru]

DoCmd.TransferText acExportDelim, specname, TableName, FileName, fieldnames

call from a button providing values as needed....

value for filename cound be:

filename=export & format(date(),shortdate)

 

[csk003]

Thanks to both of you. I could transfer a table and am looking at data formatting