Monday, March 12, 2012

Import data from Excel sheet to sql Database-asp.net 2.0

In admin tool of my application,i want to give facility to administrator that he can import
data from the Excel Sheet and can insert in sql database. for example...user id and password
that from excel sheet to user table in sql database.

how can i do this..please help me. it's urgent.

thanks

raj

Did you mean you want to customize the WebSite Admin Tool? Then why not using import/export wizard in SQL Management Studio to directly import data from excel file? I mean you can detach the database file under the app_data folder in VS2005 Solution Explorer and then attach the database in Management Studio, then you can use import/export wizard to transfer data easily. Some useful links:

How to: Attach a Database:http://msdn2.microsoft.com/en-us/library/ms190209.aspx

Import/Export Wizard:http://msdn2.microsoft.com/en-us/library/ms140052.aspx

No comments:

Post a Comment