That's correct. The "INTO CAMSSnapshot" creates a table in Access.

And I want to replicate that in SQL as well.

I realize that I will have to delete the table in my new sql db each time just prior to running this query. and, no, I don't want an "update" to the SQL table, as the other db has very dynamic data that changes, if not daily, then at least monthly.

And, also, sorry about the double-post earlier, my system locked up and I accidentally posted twice.