Exporting a query to text

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Hi,
I have a select query that runs off a form - getting one
parameter from the form.
After the query runs I want to export it as a text or csv
file. Whenever I try to do this I get an error
message "Too few parameters. Expected 1".
Can you help?
I am in Access 2000 and Windows 98.
Thanks,

Marc
 
It appears that the Export process is unaware of parameters.

Change the process so that you save the data to a table first. (i.e. Append
query to another table) Next export the table.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Right click on the query name, and choose Export. You should get prompted,
and the exp
 
Back
Top