I have a program that opens and extracts data from a Excel Spreadsheet. The Program is coded using VB6 w/SP5. The spreadsheets have 400+ rows and always 107 columns. My program stops at or near row #203 all the time. It stops no matter which spreadsheet I open. We have 55 spreadsheets I need to process. I am loading the same 6 variables over and over again. These 6 variables are written to a Access database at each pass. Because of the # of columns and rows I am writing our 400(rows) x 53(columns) or approximately 20,000 records to the Access database per file. But the program hangs on or near the 200th row. I checked my system resources while program is running and am at 70% free. Any help would be appreciated.
The version of excel and Access is from Office 97.
Thanks,
James Manning
Phone : 631-208-0943 x252