CSV- export

  • Thread starter Thread starter Sam Johnson
  • Start date Start date
S

Sam Johnson

Hi
I used the SELECT...INTO statement to export a SQL- query
results into a excel file. Now, I need just the same, but
this time, the target shall be a CSV file, divided by ';'.
How do I have to alter the SQL- statement?


Thanks
Sam
 
Sam,

Look at the TransferText method in the Help file.

BTW, look at the TransferSpreadsheet method in the Help file for exporting
Access data to Excel.
 
Back
Top