OleDbDataAdapter missing data.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an OleDbDataAdapter to read an Excel spreadsheet. It appears that the first row returned by OleDbDataAdapter is the second row of the worksheet. Am I doing something wrong ? What happened to the first row ?
 
I believe there's a setting in the connection(connection string) that you can specify to ignore the first row as the column header row. You might have set that

Suresh

----- Ginger wrote: ----

I am using an OleDbDataAdapter to read an Excel spreadsheet. It appears that the first row returned by OleDbDataAdapter is the second row of the worksheet. Am I doing something wrong ? What happened to the first row ?
 
You must log in or register to reply here.

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

OleDbDataAdapter created in code behaves differently from one created by wizard. 6
OleDbDataAdapter issue 4
Import CSV 1
Need a very small (one table) database!!! 5
Bold Text In Datgrid Row If strResult="Purchased" 7
data grid 8
delete in c# .net 1
How to persists a DataSet in a Access Table 3

Back
Top