View Single Post
  #3 (permalink)  
Old July 18th, 2008, 04:40 AM
yes_no yes_no is offline
Authorized User
Join Date: Apr 2008
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts

Hello rstelma,

Thank you for immediate reply.. I appreciated you for giving such a long list of coding..

Actually, I tried to fetch the data into DataGrid from Excel sheet.. But now my problem is that from there I want to save to the SQL database table.

or You could specify the code, that directly fetch the data from excel sheet to database table.

Yes, the user should select the excel file location and that I have done to fetch the location, but how to insert into database table.
I have the table created in SQL server database, now want only data to be inserted from Excel sheet. If u specify the ASP.NET code,it would be very helpful, though ur code helps me to get idea.