Dougpeplow
Programmer
I am using VB to open an excel s/sheet and read data into a recordset (myset = db.openrecordset etc....).
The data in the s/sheet is in a prescribed format, using first few columns as text, the remainder as numbers. The first 'record' can be at any row, and there is no header row.
the problem I have is that in order to capture the data I must always start to read from the first row. This may be full of NULLs and recordset that I create doesn't seem to be automatically able to detect the values , text or numeric in the subsequent, populated rows.
Is there a way of formatting the recordset to expect the right data type from Excel
The data in the s/sheet is in a prescribed format, using first few columns as text, the remainder as numbers. The first 'record' can be at any row, and there is no header row.
the problem I have is that in order to capture the data I must always start to read from the first row. This may be full of NULLs and recordset that I create doesn't seem to be automatically able to detect the values , text or numeric in the subsequent, populated rows.
Is there a way of formatting the recordset to expect the right data type from Excel
