I opened an Excel Spreadsheet through a Data Recordset in Visual Basic 6.0 and I'm able to move down rows. When I try to read fields half the time I can read the value but have the time I get a Numeric Overflow.
Temporary Variable = data20.recordset.fields(0)
Sometimes the Temporary Variable gets a value but sometimes I get a Numeric Overflow.
Is there a better way to read the value of the Excel Cell?