Code to execute a make table query

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

I have a make table query that I want to loop through from a list of
criteria values in another table. Is it possible to do this without using
the CreateQueryDef method (the sql select statement is 500+ characters
long)?
 
If you need to execute SQL - you can just pass it to CurrentDb.Execute
method, or docmd.RunSQL method
 
In either of the methods below is there a limitation to the length of the
SQL string? The select statement is over 500 characters.
 
as i remember - statement limit is about 2000 characters
So - do you have problems running it?
 
It works fine. I needed to copy the sql from the query into several strings
in the module, and then do some editing.

Thanks,
 
Back
Top