Is it possible to make the destination table name variable (prompted entry) for a Make-Table Query?
D djdever Jun 19, 2008 #1 Is it possible to make the destination table name variable (prompted entry) for a Make-Table Query?
M Michel Walsh Jun 19, 2008 #2 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
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
