How i upload excel file and how i add all data in my sql database ?

Posted by Parag under ASP.NET on 6/5/2008 | Views : 1894 | Status : [Member] | Replies : 4
I have 1 excel file. in file some fields like name,in time, out time, day, etc..
And My sql database has same fields table name Details.

I want to upload this excel file. And when i upload file all data set in my sql database Table(Details).

Like in Excel file field like :
Name In time Out Time
Parag 9:00 AM 7:00 PM

when i upload file i want to all data in my sql database table(Details)(at that time). Like

In my database table fields like :
Name In time Out Time
Parag 9:00 AM 7:00 PM


Give me simple coding please.

parag barot


Responses

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

Please mark as answer Resolved Posts if it helpful to you.

Mark as Answer if its helpful to you

Parag, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sandeepmhatre on: 10/1/2012 [Member] Starter | Points: 25

Up
0
Down
Best way to upload excel to database is using SSIS ie integration services.

by converting the Excel file into CSV you can upload excel file in database with less amount of code.


Sandeep M,
Software Developer
Follow me on :
http://sandeepmhatre.blogspot.in

Parag, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: SheoNarayan on: 6/5/2008 [Administrator] HonoraryPlatinum

Up
0
Down
Please look at following article for the solution.


http://lakshmik.blogspot.com/2005/12/how-to-get-excel-data-into-net-dataset.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;194124


http://mow001.blogspot.com/2005/12/using-ado-to-get-data-from-excel-to.html

Thanks


Regards,
Sheo Narayan
http://www.dotnetfunda.com

Parag, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response