tags:

views:

44

answers:

1
Q: 

Could inner excel row properties could affect oledb visibility?

ader doesn't show the first row of xls file, selected with select * from [sheet$]. Probably some inner excel row properties could affect oledb visibility?

+1  A: 

Extended Properties=""Excel 12.0; HDR=No; IMEX=1;" this property tells OLEDB to ignore the first row (it treats it as header).

rudnev  2009-10-13 13:48:11

related questions

How do I query raw data from a Proficy Historian?
Reading Excel in .NET, how to get row number?
Persuade Access 2007 to use a .UDL file/oledb connection?
OLEDB Driver Bit?
OLEDB v/s ODBC
How in .Net do I Import Values from a CSV in the format I want using OleDB?
Ignored columns using vb6 to extract from excel
System.Data.OleDb.OleDbException: Invalid internet address. How do you connect to excel files located on a webserver using OleDb
How to determine MS Access field size via OleDb
From SPSS, import data from SQL Server Analysis Services
oledb/ado.net: Get the command's text, with all parameters replaced
Import Text File into generic Database using SQL
Oracle instant client with OraOLE DB provider?
Case Sensitivity when querying SQL Server 2005 from .NET using OleDB
Good .NET ORM Framework that supports OleDb and Stored Procedures?
What is the OleDb equivalent for INFORMATION_SCHEMA
When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
How to check if an OLEDB driver is installed on the system?
what is the difference between OLE DB and ODBC data sources?
Writing into excel file with OLEDB
Managed OleDB provider written in C#
Is there anything wrong with this query?
Performance issues regarding Access 2003 and the OLE Object data type
What is this 'Multiple-step OLE DB' error?
VFP .NET OLEdb provider does not work in Win 64-Bits. Help