K
Kim Carlsen
Hi
How do I do a select from an excel file, where the headers is not in the
first row?
The first and second row contains some date and logo, so I want to start at
third row in my select.
is there some way to skip the two rows when reading?
the code looks like this:
String strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=c:\test.xlsx;Extended Properties=Excel 12.0;";
String strSelect = "SELECT [text] FROM [sheetname$]";
OleDbDataAdapter daMaster = new OleDbDataAdapter(strSelect, strConn);
Regards
Kim
How do I do a select from an excel file, where the headers is not in the
first row?
The first and second row contains some date and logo, so I want to start at
third row in my select.
is there some way to skip the two rows when reading?
the code looks like this:
String strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=c:\test.xlsx;Extended Properties=Excel 12.0;";
String strSelect = "SELECT [text] FROM [sheetname$]";
OleDbDataAdapter daMaster = new OleDbDataAdapter(strSelect, strConn);
Regards
Kim