July 16th, 2012, 12:43 PM
SQL in VBA
I am using a select into statement that creates a new table. I would like to make it so that I can run a loop that creates similar new tables. Each time a SELECT INTO statement is used, I would like for the older table to be overriden by the new table, but I keep getting the error that the original table already exists. Does anyone have any suggestions on how to do this? I am programming in VBA and therefore cannot use try catch blocks
July 16th, 2012, 05:01 PM
You'll have to add a DROP TABLE before you try to recreate a new table with SELECT INTO
The man who doesn't read good books has no advantage over the man who can't read them.
August 8th, 2012, 11:21 AM
You need to give a LOWER DINING ROOM TABLE prior to deciding to try to create a brand new desk using PICK OUT INTO.
Comments on this post