CSV- export

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
 
P

PC Datasheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Export / Import 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Sorting and filtering text 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Embed the same Excel multiple times 0
How can the font and size of (all) citation numbers be altered? 1

Top