Is it possible to run a Make Table Query that i created in Access in VB6. I copied the sql and put it in a string and used an ExecuteCommand command with a command object but it doesn't seem to work, if someone has any ideas what the problem might be or some useful code i'd appreciate it. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running a Make Table Query from VB6
- Thread starter Gaff
- Start date
This will make a new table from another tablestructure
strSql = "SELECT * INTO " & strDivName & " FROM " & "Template"
'Create a table from the template
db.Execute strSql
'If this is not what you are looking for then then is a DAO method in the FAQ
strSql = "SELECT * INTO " & strDivName & " FROM " & "Template"
'Create a table from the template
db.Execute strSql
'If this is not what you are looking for then then is a DAO method in the FAQ
- Status
Similar threads
- Question
