SQL code to get MS Access to export table to .CSV file

Hello Friends,

I am not a SQL or a MS Access programmer and so need your help.

I need code sniplet that will let me get MS Access to export my DB table to a .CSV file format.

I know how to open and close adodb connection to MS Access. So that part is taken care of.

Your help is greatly appreciated.

Thanks.

N. Alex Desh

I know only the way to read the entire table and save the content step for step in a .csv file.

Hope this helps a bit.

-Sonu