export the results of a query string to a file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Back
Top