Problems exporting query to CSV

[cathalfarrell]

Hi Everyone,

I am trying to export a query to a csv file for upload onto a bulk email system online.

I have read the other posts here regarding how to do this and am familiar with the DoCmd.TransferText function.

However I seem to be having problems creating the export specification.
When I select the query to export to text file I am presented with three export specifications.
1.Export data with layout and formatting
2.Open destination file after export
3.Export only the selected sheets

I have read from other posts that I should not select any of these options to bring up the Export Text Wizard.

When I don't select any option I get message "too few parameters. Expected 1". I have done the same with a table and don't get the error messages.

Otherwise when I export I get all sorts of mad formatting in my csv file. Pulling my hair out, please help!?!

C.

 

[DCrake]

First things first have you tried opening up the query in datasheet view. The error you are getting is query related not export related. Correct this and retry Export.

 

[cathalfarrell]

Thanks DCrake, that makes sense, just didn't realise, bit of a newbie