Recent content by min

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...

llyal, it will work. But, you open up another access window instead open the *.mdb file with the existing MS Access Application. Right?

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