Hello Everyone,
Please tell me whether any option in SQL Server to export data in file with different format such as txt, csv, xls etc. Please resolve my problem as soon as possible.
Hi Kishan,
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 toolbar. After that your data will be saved in file. But If you want more flexibility in exporting and importing data then you should use third party tool such as MindStick DataConverter, AutoConverter etc.
To download MindStick DataConverter click here