How to export data in file

PankajSukla · #1 (**permalink**) 02-13-12, 07:16

Hello Everyone,
Is there any option in MS-SQL Server to export data in file with different extensions such txt, csv, xls etc.

Please give me appropriate answer!

Wim · #2 (**permalink**) 02-13-12, 08:01

Quote:

Is there any option in MS-SQL Server to export data in file with different extensions such txt, csv, xls etc.

Yes, there is.

GauravYadav · #3 (**permalink**) 02-14-12, 03:37

Hi PankajSukla,
Yes! MS-SQL server has an option to export data in file. To export data in file, you have to select 'Result to File' or 'Result to Text' option in SQL server. After that your data will be saved in file. You can use also a third party tool to perform such kind of action. There are lots of famous tool in market which having functionality to import and export data from file. MindStick DataConverter is one of them which having such type of functionality.
MindStick DataConverter Download Path: MindStick-Unleash Your Imagination

I hope it will help you.

Internet Services

Web Development

Digital Marketing

Consumer Tech