Page 3 of 12PREVNEXT

Import data: Import external data into Excel 2003

List of different databases you can import into Excel

You can import many different kinds of databases into Excel.

Most likely the data you want to import will be stored in a corporate database. The data might be in a database on a local hard drive, or it might be in a large server database such as Microsoft SQL Server or Oracle.

Know what you want to import

You can import many different kinds of data into Excel, including Microsoft SQL Server OLAP (On-Line Analytical Processing) Services into PivotTable reports, Microsoft Access, dBASE, Microsoft FoxPro, Microsoft Excel, Oracle, Paradox, and SQL Server.

Know your connection type

Wherever the data comes from, each database management system uses a specific type of connection to enable data to be exported into Excel. You'll select the connection type in a list that you'll see in the Data Connection Wizard that you use to import the data into Excel.

For example, if your data is stored in a SQL Server database, you would pick that from the list. If you're not sure which to select, you may need to ask your system administrator whether the data is stored in a SQL server database or in an Oracle database.

Office Data Connection files

Regardless of the kind of data you import, in the process you create an Office Data Connection (.odc) file. The .odc file stores the connection information to the database, including the name and location of the database and the database driver, which is software that connects to database programs.

Once you create an .odc file, you can use it again to connect to the same table in the database. For example, you might want to create a new workbook later on to do different analyses with the same data.

Page 3 of 12PREVNEXT