Export Script (Query) for MS Access

[dhrehor]

ignorant question, but is there a way to automate the export of a table either via command line or via a query (SQL)?

I currently have several queries in a macro. At the end of the macro, I would like to export a table in comma delimited format with the field names as the first record.

thanks guys

 

[PHV]

Have a look at TransferText

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886