exporting table or query

[Tom Tripicchio]

I am using access 97.

Is there a way to export a table or query from access into a .csv file in
another directory on my "C" drive?

Thanks.

 

[Duane Hookom]

Try right-click the table name and see what options might be available.

 

[Brian]

If you want to repeat or automate it, look at the TransferText method in VBA
help.