Article ID: 190195 - View products that this article applies to.
If there is a column in your Excel spreadsheet that contains both text and numbers, the ISAM will not be able to correctly interpret which datatype it should be. Make sure that all the cells in a column are formatted to be the same datatype. For example, you might have following data in four columns in an Excel sheet:
male female children teens 11 cc 78 ee 22 xx 33 ff 45 uu 56 oo
If you try to read the data through ISAM driver against the whole sheet, you will get the null values for first row. If you want to avoid this, create named ranges: one containing only the header information and another containing the data information. For example:
named range 'myRange1' : male female children teens named range 'myRange2' : 11 cc 78 ee 22 xx 33 ff 45 uu 56 oo
Now you can connect to Excel and request information only from the particular named range. However, in one range, a particular column can contain only one type of data.
How to Create a RangeFollow these steps in order to create a range:
To retrieve your data, use the range name you just created for the table name in your select statement.
Visual Basic Steps
11 cc 78 ee 22 xx 33 ff 45 uu 56 oo
Please refer to the documentation for how to connect to Excel through DAO. Another good reference will be the upcoming ADO->Excel reference.
Article ID: 190195 - Last Review: June 22, 2014 - Revision: 4.0
Contact us for more help