Export table Automation

Hi,

Is there a way, either with code or a macro, that i could create a button
on a form that converts a table to a .txt file?.....any help would be much
appreciated. Thanks!

--
Message posted via http://www.accessmonster.com

re: Export table Automation

Option Compare Database
Option Explicit

'------------------------------------------------------------
' mcrExportTable
'
'------------------------------------------------------------
Function mcrExportTable(byval strTable as String)
On Error GoTo mcrExportTable_Err

DoCmd.TransferText acExportDelim, "", strTable, "yes", False, ""


mcrExportTable_Exit:
Exit Function

mcrExportTable_Err:
MsgBox Error$
Resume mcrExportTable_Exit

End Function