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 : 3701 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

0	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

Latest Posts