Upload data from excel file to databse.
-
Hi Here i am trying to do is i have one excel file has some data called emails. Now i want to read that data from excel sheet and send to databese table. How can i do it using c#.
try and try untill reach success..
-
Hi Here i am trying to do is i have one excel file has some data called emails. Now i want to read that data from excel sheet and send to databese table. How can i do it using c#.
try and try untill reach success..
-
Hi Here i am trying to do is i have one excel file has some data called emails. Now i want to read that data from excel sheet and send to databese table. How can i do it using c#.
try and try untill reach success..
-
Hi Here i am trying to do is i have one excel file has some data called emails. Now i want to read that data from excel sheet and send to databese table. How can i do it using c#.
try and try untill reach success..
you can also upload excel file through SSIS which is included in MS SQL Server 2005.
-
Hi Here i am trying to do is i have one excel file has some data called emails. Now i want to read that data from excel sheet and send to databese table. How can i do it using c#.
try and try untill reach success..
1-set the database 2-if you want to show the process make DataGraidView and set it as the database 3-then copy all the data from excel file to DataGraidView 4-then each row insert it into data base (there is a lot of articles in code project explain how to read write from excel file)
EASY COME EASY GO
-
Hi Here i am trying to do is i have one excel file has some data called emails. Now i want to read that data from excel sheet and send to databese table. How can i do it using c#.
try and try untill reach success..
Hi, You can make use of OLEDB connection.(Microsoft.Jet.OLEDB.4.0) so that u can access sheet with SQL Query. like select * from [sheet1] Hope this could help you, Regards Surender No Defeat Is Final Until You Stop Trying!.......
-
There are several ways, probably the easiest is to read the excel file using ODBC - although you can also do this using SQL Server Manager and importing your data if its a one off load.
Bob Ashfield Consultants Ltd
Hi Bob!!! Thanks for reply.
try and try untill reach success..
-
Hi, You can make use of OLEDB connection.(Microsoft.Jet.OLEDB.4.0) so that u can access sheet with SQL Query. like select * from [sheet1] Hope this could help you, Regards Surender No Defeat Is Final Until You Stop Trying!.......
Hi surender thanks for reply, actallu i m doing same way
try and try untill reach success..