General discussion

Locked

Reading an Excel Spreadsheet using VB

By jmanning ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Reading an Excel Spreadsheet using VB

by SteveD In reply to Reading an Excel Spreadsh ...

I can't solve the VB6 problem but I can suggest a workaround. Try using the Access Import Wizard to import one of the spreadsheets directly into an Access table. If that works, you should be able to automate the function for your 55 spreadsheets using the TransferSpreadsheet macro command. Then use Access VBA code instead of VB to process the data.

I hope this helps.

Steve Diamond

Collapse -

Reading an Excel Spreadsheet using VB

by jmanning In reply to Reading an Excel Spreadsh ...

Tried the import wizard, but the heading for every other column is a week ending date , which I need in a seperate field by itself.

Thanks anyway.

Collapse -

Reading an Excel Spreadsheet using VB

by jmanning In reply to Reading an Excel Spreadsh ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums