Exporting a Database

Hi everyone.

I was curious how I could export my database into an Excel or Access File. I am currently with a hosting company that isn't suiting my needs and I would like to export my database before I tell them I'm moving to somewhere different. I connect to a MSSQL database using enterprise manager via a browser. I was curious if there are any free programs or SQL commands for exporting the database to my PC.

Thanks for your help


Wes

I'm not familiar with the browser environment of SQL server manager, but if you have the client version, you can do the following:

1. Right click on your db at hosting server
2. Click All tasks/Export data
3. Click Next
4. Choose (from where) your hosted db's info from select options
5. Choose (to where) how you want to export information from Destination select box (ie. local server, csv file, text file, excel file...) & Chose file name if necessary.
6. Select either a query or just copy tables directly by selecting appropriate radio button.
7. Select source tables by checking boxes next to the listed tables and click 'next'.
8. Click 'Run Immediately' & click next.
9. Click 'Finish'
10. Go check out your file.