How to export SQL SERVER 2000 DATABASE Information into EXCEL SHEET 2007

Posted on 2009-05-26
Medium Priority
Last Modified: 2012-05-07
I need to transfer the records from sql server 2000 into excel sheet 2007
Question by:Aijaz1982
  • 2
LVL 25

Accepted Solution

slam69 earned 1500 total points
ID: 24470845

Here's the steps for you to refer.

1. Create a File DSN for Microsoft Excel Driver.

Control Panel -> Administrative Tools -> Data Source (ODBC). Switch to the File DSN tab and click "Add". In the dropdownlist, select "Microsoft Excel Driver (*.xls,*.xlsx,*.xlsm,*.xlsb)" . Click "next", create the name of the DSN and click next,  click "finish" to create the DSN file you just configered. Then you'll see a dialoguebox named "ODBC Microsoft Excel Setup", Choose "Excel 12.0" in the version list of database and click "OK". Finally a dialoguebox named "Select workbook" will appear and please set the target excel file's path and click "OK". You'll see a new .dsn file has been set up.

2. Use DTS to export the data to Excel2007 file.

Open your SQLServer Enterprise Manager, right click the database and choose "All Tasks->Export Data". When choosing a Destination, you should choose "Microsoft Excel Driver (*.xls,*.xlsx,*.xlsm,*.xlsb)" and make the File DSN radio button checked, select the DSN file you set just now. (Generally the file is located in /Program Files/Common Files/ODBC/Data Source/..)

Through the steps above, you can export the data to Excel2007 file from SQLServer2000.

LVL 25

Expert Comment

ID: 24470847

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question