Access hangs while updating tables from an Excel file

[RemiWoler]

In the code of the form, it opens the excel file, reads all values to a new table. Then it compares the new table with an existing table where it updates (FindFirst) or adds the record, containing the same article number. When it added/updated 7777 records, Access won't respond any more. Clicking on the close tab, results in the well known Windows XP send error form. It doesn't matter if I let it hang for 10 seconds, or for 10 hours. It allways won't do record 7778 and up. (NOTE: The tables are upsized to an MsSQL 2000 SP3 database). Am I bouncing to some limit? It isn't a possibility that there is an error in the record. Cause the only difference from the previous record is that the word "green" becomes "black". Also if i delete some source records, it still won't pass the 7777. I hope someone knows what's going on, or gives me a way to trace the proces in a log file. (The eventviewer of the server, nor the one from the client pc shows something (except the hungapp of Access), and i even can't find something in the Errorlogs of MsSQL.)

 

[BillPower]

Hi RemiWoler,

I just imported 3 15,000 row sheets from a workbook using Import Multiple Excel Worksheets into Access which can be found at:

http://www.wpower.fsbusiness.co.uk/

The help file explains what to do.

If you still have problems after using this then send the offending workbook to billpower@cwcom.net so that I can have a look at it.

Bill