is there any way to export a table to a file without any additional tools? I can't install anything on that server.
Asked
Active
Viewed 945 times
2 Answers
1
Many ways to do this. i dont know exactly how you wanted your results but I will throw some options.
If it is a one time thing you can run a query(select * from YourTable if you need all the data in the table) using SSMS and then right click on the results and save it as text/csv file. If you want to do this programatically you can use bcp utility. You can also use integration services to export data; if you dont have SSIS on the target machine you can build your package inside another machine that do have SSIS and point it to your table as long as you have access to the table in the source.
DaniSQL
- 1,097
- 7
- 12
-
He specified Express, which iirc doesn't come with integration services. But +1 for the other parts. – Joel Coel Dec 02 '10 at 03:01
0
Would the results to text or results to file function work for you? The option to do this is located in the toolbar above the query window.
Sean Howat
- 1,849
- 4
- 20
- 33