i'm getting various errors when i try to use the INTO clause.

is this feature not supported?
example:   select * into newtable from customer

No you can't create tables in QuickBooks using QODBC. In MS Access do a append query, something like:

INSERT INTO tblAcct (ListID, Name, IsActive, FullName, AccountType, AccountNumber)
SELECT Account.ListID, Account.Name, Account.IsActive, Account.FullName,
Account.AccountType, Account.AccountNumber
FROM Account;

tblAcct is a local MS Acces table and Account is a QODBC/QuickBooks table.

i'm lost.

how does the sql tell qodbc that the tblACCT is in access..... because the connection string is pointing to qodbc?

ahhhhhh,      i think you believe that i have linked the QB tables inside msaccess.
there are no linked tables, so i cant reference the QB tables directly from msaccess.
there are just too many tables to have them all linked up, too many dde requests-possible broken links, and speed issues.

i have to create a query in access that can point to data outside the database (without being 'linked' in access).
----how would i include the QODBC connectionstring in an sql string----that way it would know where the data was coming from when the query runs......

OR,
i have to execute the qodbc query in VBA code, and save THOSE records in a table inside access, so an access report can run against it. ----but not sure how to move the records returned from the qodbc query into an access table, WHILE the qodbc connection is still active.

ahhhhhhh, I think you believe this is a MS Access support forum. You can link external tables using a sub-procedure, see: When I use Linked tables in MS Access the ODBC link locks-up? 

i'm not intending to misuse this help center, i appologise for my persistence.
I have been to the microsoft forums but havent gotten anything useful there, except a couple folks who suggested that the people who handle the odbc should know. so here i am.

thanks for the link, but unless i miss my guess, that code looks like it does the same thing as if i were to link the table into access, which is what i'm trying NOT to do.

i'm looking for a way to do a select-into which reads the qodbc and creates a table in access.

QODBC is a ODBC driver. Normally to use QODBC in MS Access you must either link or import the external table. Tables can be linked individually and even linked and unlinked within a sub-procedure.

But in this example: Running an sp_report in Access using VBA you will find what you've looking for.