It seemd we have a pretty simple solutions for table/query import/export
-------------
DoCmd.TransferText acExportDelim, , "Country Query", "C:\temp\April.txt"
DoCmd.TransferText acImportDelim, , "april", "c:\temp\april.txt"
-------------
Min
Or use this method if you already has a query created
----------------------
TransferText Method Example
The following example exports the data from the Microsoft Access table External Report to the delimited text file April.doc by using the specification Standard Output:
DoCmd.TransferText...
I am not sure if you can write to a txt file directly from Access. But here is a work around solution. Put this function into form or anywhere else and when it runs, it output your query into a word doc first, then save it as a tab delimited txt file.
-------------------------------------...
Needs Help!
Anybody knows how to trigger a function whenever a new record is inserted into a table? Basically, this function is to update a field in another table.
Thanks, Min