Querying an Excel Spreadsheet and using GetRows to get it all records into an array
Posted on 2002-04-25
I am trying to query a spreadsheet, put the retrieved recordset into an array, and then insert this array into an access database. Problem is getting this error....
logic as follows
Connecting to Excel spreadsheet using ADO (fine)
Retrieving all columns in a specified area (ie category_area)
Using GetRows on the recordset to create an array
(This is the line in the code that the error occurs on)
Getting the following error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Excel Driver] Numeric field overflow.
Had a look about but no real answers on how to solve this problem.
Excel spreadsheet contains about 10 columns of mixed format types text and numbers. Some of the colums can be null, blank or incomplete in terms of the data format within the table in Access I am trying to insert them into, but I will catch they sort of errors over at the Access side.
I can output some results by just doing rsInsert("fldID") but I need to grab all of the records at once and insert them into a database.
Can anyone help me... does GetRows work when using a recordset generated from an Excel spreadsheet, why is the milka cow lilac.....
Cheers in advance