different format store data in sql server 2005

Posted by Rajesh081725 under Sql Server on 10/27/2012 | Points: 10 | Views : 1043 | Status : [Member] | Replies : 2
what are the freature importing data an exporting data with different format for example sql to excel and sql to xml and other format in sql server 2005
All are given some example and explain procedure how to use step by step

Time is Gold
Thanks & Regards,
Rajesh Kumar,


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

The scenarios are,
a. You may have any application which accepts only the data in xml/ excel/csv/text format but your data is exist only in sql format, then you can use those in-built feature in sql server to export the data in the speicifed format. And vice versa for importing data. The client/ other application may produe the data in other format and if you want to import the data in your sql server then you can use import feature
b. There are many way to import/ export
i. Writing own .net code
ii. Thridparty tool
iii. Using SSIS Package
IV. SQL Server management studio import/Export wizard

MCTS(SQL Server & BI)

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

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

Here is a project, may help you, you can view the code in this project directly:


Never give up! Smile to the world!

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

Login to post response