Export the data from different tables in our shared SQL environment?
Using Enterprise Manager
Expand SQL Server group
Expand the server name
Expand the database that you’ll be exporting data from
Click on Tables
Right-click the table you’d like to export, select All Tasks -> Export Data
The first dialog box asks where you’ll be copying the data from, just click Next
The next dialog box asks where you’ll be putting the data. You have a variety of options here, depending on what you’re trying to accomplishing. You can export the data to another SQL Server database, an Oracle database, an Excel spreadsheet, or even a plain text file. Follow the wizard to complete the task and export the data.