How to fetch an ODBC table into DAO recordset?

[RandV]

I should be able to get this but my heads a little frazzled with a cold right now. I'm doing some work in on SQL database in a roundabout way because I couldn't set an ODBC link for a few tables. Rather than link the SQL table into access dump my data into a temp access table, I need to link the SQL table and dump it into a temp linked SQL table.

SQL Passthrough qry 1 - DROP TABLE TEMP; (if exists)
SQL Passthrough qry 2 - SELECT (...) INTO TEMP FROM (...);
SQL Passthrough qry 3 - SELECT * FROM TEMP;
SQL Passthrough qry 4 - INSERT INTO LIVE FROM TEMP;



I need to pull step 3 into into a DAO Recordset or QueryDef to do some row by row updates, but can't quite seem to get it. Any idea's what would work best?

[RandV]

Never mind, I was able to work it out... now how do you set a thread as solved?