Do you use the built-in method TransferSpreadsheet, do you attach you database to the Excel file (Linked table) or do you use a function you wrote to tranfer the data from the worksheet into an Access table?
There is no code involved. The database contains only a select query and an empty table which contains the table structure. I copy the empty table structure to a new table (structure only). I am using the built in Excel import function to append the records into the empty table.
I know the data itself is good, because I can segment it and all the segments import successfully and can be appended together into a single table.
It only chokes if I try to import a segment larger than 350K Excel records. I don't know the exact record count. I was able to bring in a 350K chunk, but it fails every time when attempting a 400K segment.
I click the External Data tab, then click Excel. I navigate to the folder that contains the Excel data that I wish to import, and select the file. I select the 'Append a copy of the records to the table:' radio button and select the empty table I want to import the data into from the selection box, and click OK.