loading data into access - Crashed / Access shuts down and closed

[johnseito]

I use this code to load excel file into access and access crashed and shuts down.



DoCmd.TransferSpreadsheet acImport, , "table" path + file, true, "sheet!"

normally it doesn't, not sure if because I have a huge query that does many aggregation that does it.

Anyone know why ? Thx

[John_G]

If you have a "huge" query with many joins and a large number of records, it is possible that the 2 GB size limit will be reached - I've seen it happen.

How many records are you importing, and how big is each one? Is it crashing on the import, or when you try to run the query afterwards?
How big is the Access .accdb file?

You could try a compact and repair before running the import.