Save Transform query results to a table

[srobiolle]

Hi everybody,

Here is my problem : I have a TRANSFORM Query that works great. I would like to automatically run the query and save the results to a table (with VBA) . I have worked around Recordset and DoCmd, but can't succeed.
Any help ?

Thanks
Stéphane

 

[oharab]

Why don't you just save the transform query as a query definition, then create a MakeTable query using the saved query.

In VBA you just need to
currentdb.execute "qryCreateTableFromTransformedQuery"

to run it.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[srobiolle]

I just discovered that it is possible to do a
"SELECT * from [query]" : it is perfect from me !

Thanks,
Stéphane