Export a Table to a Text File

L

Lillian

How do I export a Table to a text file?
I need Fixed with and have a import specification.
I can import from a text file to a table but now I need the other way.

I have the table ready using queries and all I need is this last step.
 
A

Allen Browne

Create a macro with the TransferText action.

It's quite easy to set the options in the lower pane of the macro design
window.
 

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

Fixed Numbers 3
append query exclude error data 1
Importing Text Files Into Access 1
Formatting Query 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
how to export MDB file from the command line in Windows? 1
Export table to txt file with a variable filename 0
Exporting Date using Query 1

Top