different format store data in sql server 2005

Posted by Rajesh081725 under Sql Server on 10/27/2012 | Points: 10 | Views : 1979 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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,
9962038582.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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 Thanks, R.Vasanth MCTS(SQL Server & BI) http://bigdatatech.blogspot.com Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

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

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: Megan00 on: 11/16/2012 [Member] Starter | Points: 25

0	Here is a project, may help you, you can view the code in this project directly: http://exportdata.codeplex.com Never give up! Smile to the world! http://excelcsharp.blog.com/ Rajesh081725, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts