export the results of a query string to a file

[srmousse]

Okay, I have a multi-functional question...

I have created a form that will allow for complex querying of my business contacts. I have successfully completed the code used to create the query string. Now I just need to be able export the query results and use them in the following three ways:

Regular "Query Type" Access Table (that should be simple)
Microsoft Excel Spreadsheet (The MAJOR Goal)
CSV File

Now, it doesn't REALLY matter to me if the file is formatted and saved right from the form or if the corresponding program is opened and the data is inserted with or without the file being saved, HOWEVER In my perfect world, the "Query Type" would just open like a table and the Excel and CSV would open excel with the data and open the "Save As" option.

Thanks for all of you help!

 

[ghudson]

Check out the TransferSpread method. You will have to output [transfer] your data as a text file and give the file name a .csv extension to create the CSV file.