Error Reading Excel Numeric Column Names

R

Rohit

I am using GetOleDbSchemaTable to read the data from the Excel file. It is
working fine with all workbook/worksheets except the one that has numeric
column names as headers.

The connection string is
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
finfo.FullName + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'"
 
P

Paul Clement

¤ I am using GetOleDbSchemaTable to read the data from the Excel file. It is
¤ working fine with all workbook/worksheets except the one that has numeric
¤ column names as headers.
¤
¤ The connection string is
¤ strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
¤ finfo.FullName + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'"
¤

Numeric values are not valid column names. Those columns names will be changed to the default column
names when no header is specified (e.g. F1, F2, F3, etc.).


Paul
~~~~
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OleDb Provider for Excel Not Reading Properly 3
What IMEX mean in connection string with Excel 3
Opening from Excel into a dataset, issue with mixed datatypes 1
excel question 2
Version of Excel in Connection String 1
ADO with mixed data 2
Connections when reading excel into dataset 1
Accessing Excel thru Jet gives data in scientific notation 6

Top