Search results

  1. B

    select into

    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...
  2. B

    select into

    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.
Back
Top Bottom