Make-Table Destination Table Name

D

djdever

Is it possible to make the destination table name variable (prompted entry)
for a Make-Table Query?
 
M

Michel Walsh

Not by syntax, but you can make a string that is a valid SQL statement, and
execute that string (with CurrentDb.Execute, or DoCmd.RunSQL, as example).



Hoping it may help
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Know Thyself? 7
Make Table Query - New Field Name 3
Criteria in append querie 3
Query that make table in another database 2
Change source/destination of Append Query on-the-fly? 1
filtering integers in a field 6
Append query with an Inner Join to Destination Table Not working 2
Append Query is not working 1

Top