table to text file

[msebastian]

Hello vb/access peoples of the world,
How exactly would I go about converting a table to a text file.

Thank ye kindly,
Matt

[Dr_Evil]

To export to a text file follow these steps.

1. Right click on the table that contains your data.
2. Click Save As/Export.
3. Select External File.
4. Change type to text file then click export. This will open up a wizard.
5. Here choose delimited and click next.
6. Select the delimiter you wish to use. You can set the "Text Qualifier" to none also.
7. Now click next and then Finish.

This should help you get your data moved. Good luck.

[msebastian]

I just figured that out after I posted this question, but the damn thing won't let me open up the file, and mess around with it. Thanks though.

[msebastian]

Is there anyway to do this programmatically using the VBA?