Export a Table to a Text File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lillian - 23 Feb 2008 18:33 GMT

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.

Reply to this Message

Allen Browne - 24 Feb 2008 07:34 GMT

Create a macro with the TransferText action.

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

Reply to this Message