storing data into DataSet from excel file using Oledb provider

Question

0.00/5 (No votes)

See more:

I'm storing data into DataSet from excel file using Oledb provider in asp.net c# application.

query: SELECT * FROM [Sheet1$]

everything is working fine but my concern is that 1st row should be skiped and 2nd row should be used for heading and rest for datarow.

I need help on urgent basis.

thanks

Posted 6-Apr-11 21:06pm

trilokharry

Add a Solution

Comments

[no name] 7-Apr-11 5:57am

where is your connectionstring?

4 solutions

Solution 1

I believe thats not possible

Microsoft
With Excel workbooks, the first row in a range is the header row (or field names) by default. If the first range does not contain headers, you can specify HDR=NO in the extended properties in your connection string. If you specify HDR=NO in the connection string, the Jet OLE DB provider automatically names the fields for you (F1 represents the first field, F2 represents the second field, and so on).

MS Support[^]

However, you can do some fancy stuff by setting the HDR=NO, selecting all the records, and then from there, recreating the Dataset.

Posted 6-Apr-11 21:24pm

walterhevedeich

Solution 2

This might be useful to you. Excel With OLEDB

Posted 6-Apr-11 23:12pm

avigodse

Solution 3

Please Explain your Question:

To Skip first certain no row you you can use this code to fill your dataset

OleDbDataAdapter da = new OleDbDataAdapter("Querytext",[Connectionobj]);
da.Fill(ds, startindex, MaxRecord, "name");

Posted 7-Apr-11 1:09am

ParthaDinda

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2011-04-07T09:08:00

Solution 4

You could try defining the range. Something like:

SELECT * FROM [Sheet1$A2:X999]

Posted 7-Apr-11 9:08am

Wendelius

Comments

trilokharry 8-Apr-11 1:02am

thanks a lot.....
It's working fine.

Wendelius 8-Apr-11 1:29am

Glad it helped :)

storing data into DataSet from excel file using Oledb provider

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

storing data into DataSet from excel file using Oledb provider

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us