Export Query result To A Table

[azzi2000]

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é

[MMcCarthy]

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é

[azzi2000]

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é

[cynicon]

Use

DoCmd.SetWarnin gs False
DoCmd.SetWarnin gs True

To avoid interruptions =)