select into

[b5white]

I have a query that selects data. Works great.
I add 'INTO TempTable' before FROM and run it.
Appears to work, returns the data, but doesn't create or populate the table.

And if I run the query using conn.Execute it gets an error but the Err ID is 0.

Not sure how to debug this.

 

[jdraw]

I recommend that you go to the SQL view of your query; copy the SQL and paste it into a Post.
Does "TempTable" exist?
Good SQL reference and tutorials at W3Shools

 

[b5white]

Thanks for the reply.

"I have a query that selects data. Works great.
I add 'INTO TempTable' before FROM and run it.
Appears to work, returns the data, but doesn't create or populate the table."

Turns out I was taking a shortcut that appeared to work.
I was flipping from SQL view to table view, which works fine for SELECT statements.
But it was only showing the existing data and wasn't actually running the query.

"Run" is the ticket. Once I did that, it failed and was easy to debug. ¯\_(ツ)_/¯