Page 6 of 12PREVNEXT

Import data: Import external data into Excel 2003

Microsoft SQL Server is selected as a connection type, and a user name and password are entered in the Data Connection Wizard. An .odc file is created from a database and imported into Excel.

Now we'll see how to import the product data if it is stored on a Microsoft SQL Server instead of on a local hard drive.

SQL Server, called OLE DB, is a newer standard than ODBC DSN, and supports more data types, including images and sounds.

In the first step of the Data Connection Wizard, you select Microsoft SQL Server in the list, and then click Next.

In the next step, you enter the server name. If server log on credentials are necessary, you enter your user name and password. Otherwise, choose Windows Authentication.

In the third step of the wizard, select the database that contains the data you want, and select the table you want to connect to.

In the final step of the wizard, Excel names your .odc file (or you can pick another name). Then you click Finish.

The Select Data Source dialog box opens again, this time with your new .odc file in the list of files. You select the .odc file and click Open. Before you import the data into Excel, you have the option to create a PivotTable report or to just import the data as is into Excel. As a final step, if you entered your user name and password previously, you must enter them once again. Then the data is imported into Excel.

Click the Play button on the left to see an animated example of creating a SQL connection.

Page 6 of 12PREVNEXT