Sql server 2005 table to excel and excel data to sql server

Posted by Rajesh081725 under Sql Server on 10/27/2012 | Points: 10 | Views : 2597 | Status : [Member] | Replies : 4
Can any one know

How to import the Sql server 2005 table to Excel and also Excel sheet import to Sql server 2005

Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.



Responses

Posted by: Krv on: 11/8/2012 [Member] Starter | Points: 25

Up
0
Down
a. You can create SSIS package to import/ export data from excel to sql
b. You can use Import/Export feature provided by sql server database (Open Management studio, Connect the database, Right click the db -->Task-->Import/Export data and you will find easy wizard to do your requirement


Thanks,
R.Vasanth
MCTS(SQL Server & BI)
http://bigdatatech.blogspot.com

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

Posted by: Rajesh081725 on: 11/8/2012 [Member] Bronze | Points: 25

Up
0
Down
Hai Krv,
i want witnout using SSIS any different simple method directrly handled some menu contrl or some option

Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.

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

Posted by: Megan00 on: 11/9/2012 [Member] Starter | Points: 25

Up
0
Down
You can first export excel to datatable or import datatable to excel, so see this article, it may helps you:
http://excelcsharp.blog.com/2012/10/29/export-excel-to-datatable-and-import-datatable-to-excel/

Never give up! Smile to the world!
http://excelcsharp.blog.com/

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

Posted by: Krv on: 11/18/2012 [Member] Starter | Points: 25

Up
0
Down
Below article shows how to import/ export excel data.
http://www.c-sharpcorner.com/uploadfile/ae35ca/read-and-write-excel-data-using-C-Sharp/
Then using sql command insert it into database

Thanks,
R.Vasanth
MCTS(SQL Server & BI)
http://bigdatatech.blogspot.com

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

Login to post response