By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 803 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Export Query result To A Table

P: 6
This should be rather simple.
I have a query using different link tables and 2 parameters.
The query works perfect.

However I need to export or save the result in an Access table in order to export it to an ascii file delimited. (Quote delimited with comma)
- I tried to export to an ascii but I am getting: Too few parameters.

It would be best if I can export the result to an Access table then export the result using the specs built in access export.
Please help.
Thank you.
André
Oct 20 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Have you tried changing the query type to a Make-Table Query. In query design go to the query menu and select it.
This should be rather simple.

I have a query using different link tables and 2 parameters.
The query works perfect.

However I need to export or save the result in an Access table in order to export it to an ascii file delimited. (Quote delimited with comma)
- I tried to export to an ascii but I am getting: Too few parameters.

It would be best if I can export the result to an Access table then export the result using the specs built in access export.
Please help.
Thank you.
André
Oct 20 '06 #2

P: 6
Have you tried changing the query type to a Make-Table Query. In query design go to the query menu and select it.
This is exactly what I waas looking For.
THANK YOU. THANK YOU.
André
Oct 20 '06 #3

P: 20
Use

DoCmd.SetWarnings False
DoCmd.SetWarnings True

To avoid interruptions =)
Feb 15 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.