Copy to In Memory Database via ODBC Connection

I would like to copy over a few columns of a table that is accessed via and ODBC connection, into an in-memory database. Is there anyway to do this using a CREATE SELECT statement?

This only works if two databases are connected with the same connection. SQLite does this. Not sure about ODBC.

You may need to query in one and run loop over records to perform insert with prepared statement.