Is there any way to import data from pass-through query into access db table?

[jaik11]

Hi,

I am trying to import the pass-through query data into access database table.
query has about 9.3m rows and its about 700mb with excel files.
I was trying to do insert statement below, but giving me the data is too large message.

INSERT INTO Report
SELECT *
FROM PT_TEST_DATA;

I do not have anything except pass-through query and empty table for the data import in my Access database.
Is there any ways to make this import from pass-through query?



Anything helps!

[ssanfu]

"REPORT" is a reserved word in Access and shouldn't be used as an object name.
If "REPORT" is the name of a table, rename it to something like "tblREPORT".

Does the table you are trying to import the data into have the same number of fields and the same data types as the pass-through query? ("pass-through query" implies the data is from SQL Server/MySQL.)


You might try selecting fewer records to see if the queries are working correctly. Try limiting the pass-through query to 1000 records and execute the append query.