transfer data from excel file into sql server table
ASP.NET
4
Posts
3
Posters
0
Views
1
Watching
-
first you must select a database and tables from enterprise manager which you want to insert excel table into. then click the right button of the mouse and select import data. The menu steps show you how to solve this problem.
-
first you must select a database and tables from enterprise manager which you want to insert excel table into. then click the right button of the mouse and select import data. The menu steps show you how to solve this problem.
-
but i can't use enterprise manager i have to do that programatically in my asp.net application.
Two steps 1. Read Excel file into a dataset. http://www.codeproject.com/csharp/Excel_using_OLEDB.asp[^] 2. Insert values from dataset into sql server table.