Macro Help Needed to Export Table

  • Thread starter Thread starter Terry DeJournett
  • Start date Start date
T

Terry DeJournett

Does anyone know how to write a macro to take a table in Access and export
it out as a "text" file?

Thanks in advance.
T.D.
 
DoCmd.TransferText acExportDelim, , "Table1", "C:\Temp\output.txt"

Will give you a comma seperated text file. Search help on transfertext
for how to customise the export to your exact requirements...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help exporting an Office 365 mailbox to PST 1
How to Export Gmail Emails to PST Format? 4
Export Access table to excel using macro 1
Automate Change of the format of a field to short date for export 2
Exporting Access query to Excel file with passwords 6
Exporting design view tables 0
Export to Excel 3
Multiple TransferText to the same File - Need to Append not Overwrite 2

Back
Top