Hi

I have some problem with extracting excell data. It alwasy miss the first row. Any one have any Idea what is the problem? Is it a DOTNET bug?
**********CODE***************
String temp="Select * From ["+ this.txtSheet.Text+"$"+this.txtStarting_cell.Text+ ":"+this.txtEnd_cell.Text+"]";
String path=this.txtSaveF.Text;
String temprec;
System.Data.DataSet DS;
System.Data.OleDb.OleDbDataAdapter MyCommand;
System.Data.OleDb.OleDbConnection MyConnection;
MyConnectHi

I have some problem with extracting excell data. It alwasy miss the first row. Any one have any Idea what is the problem? Is it a DOTNET bug
**********CODE***************
String temp="Select * From ["+ this.txtSheet.Text+"$"+this.txtStarting_cell.Text+ ":"+this.txtEnd_cell.Text+"]";
String path=this.txtSaveF.Text;
String temprec;
System.Data.DataSet DS;
System.Data.OleDb.OleDbDataAdapter MyCommand;
System.Data.OleDb.OleDbConnection MyConnection;
MyConnection = new System.Data.OleDb.OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0; " +"data source=" +this.txtOpenF.Text + "; Extended Properties=Excel 8.0; ");
// Select the data from Sheet1 of the workbook.
MyCommand = new System.Data.OleDb.OleDbDataAdapter(temp, MyConnection);
DS = new System.Data.DataSet();
MyCommand.Fill(DS);ion = new System.Data.OleDb.OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0; " +"data source=" +this.txtOpenF.Text + "; Extended Properties=Excel 8.0; ");
// Select the data from Sheet1 of the workbook.
MyCommand = new System.Data.OleDb.OleDbDataAdapter(temp, MyConnection);
DS = new System.Data.DataSet();
MyCommand.Fill(DS);

Hi there,

You may want to look here: http://www.connectionstrings.com/ under Excel.

You can see the connectionstring has an HDR attribute. When set to False, the first row is not assumed to contain the headers. Maybe that helps.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004