Hi!,

Check if there is some code in the procedure dropping the table, because i've tried that way, and it works.

You can also create the table structure with the EXEC command,

see the books online for more information about the EXEC,


Also check the String that's being generated with the fields

You can use this exampe with the authors table on the Pubs database from Sql Server:

exec ('select Au_LName, Au_FName, Phone into tmpAuthors from Authors where State = "CA"')

It'll work, check it out.

good luck