How do I export an SQL database into Excel?

Question

I have been nominated as the keeper of my company's SQL database, despite not working in IT or having any training.

I have an SQL database which I need to export into Excel. The only thing I can find is the option to 'Extract Database', and this only offers me the option of exporting into SQL script (a .sql file) to be placed on my desktop.

Does anyone have any ideas on what to do? I'm using 'SQL Manager 2005 Lite for SQL Server' if that means anything.

Any advice very much appreciated!

Answer 1

If you just want a single table then it will be easier to import it into Excel. Use the Import Data option (Tools, Data, Import Data).



I don't know about SQL Manager 2005 Lite, but in SQL Server Management Studio right click on the database and choose All Tasks, then export. This will start the Import and Export Wizard which is quite self explanatory.



Good luck...

Answer 2

Get the training. Unless your SQL database comprises a single table you are going in the wrong direction with your company data. (If you really want to persist with this the VLOOKUP function in Excel provides some ability to bring information together from different tables)

Answer 3

SQL Manager 2005 has three related features: Export Data function, Extract Database, and Export As SQL Script functions. The Extract Database feature is not the proper feature to use to export a database to Excel. Instead, try the Export Data function.



* Exports data to most popular formats: MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.

* Exports data to MS Access

______________________________________________________________________



This link has background information on SQL Manager.



http://www.sqlmanager.net/en/products/mssql/manager/features



EMS Database Management Solutions

______________________________________________________________________



This link has the FAQs about SQL Manager:



http://www.sqlmanager.net/products/mssql/manager/faq



A relevant FAQ for you:



Q:

What is the difference between the Extract Database and Export As SQL Script functions?

A:

Export As SQL Script is intended to export table data that will be inserted into a database system other than MS SQL Server or MSDE. Use Extract Database to copy data to a table on MS SQL server.

____________________________________________________________________

Answer 4

I agree with Mark, which is if you're using 2003 version or earlier. If you have 2007, however, its Data from the menu bar then get external data and then all the different locations are shown and you click on Access and follow the instructions. My question however would be why is it necessary to export it to Excel.

Answer 5

seen undemanding for application is the way ... then you definately will do the sparkling up by utilising some macro this is not see you later to benefit it, in spite of the shown fact that it demands stamina ;-) My terrific suggestion, learn it, practice it and you will not be apologetic approximately (beeing a grasp in Excel have a great form of advantages) start up immediately: attempt to checklist your sparkling up utilising the macro recorder gadget. Press ALT+F11 and look into the code. Your project is to make the code versatile adequate so as that it ought to be used for any import solid success

Answer 6

Try creating a DTS for the task....