Importing data from databases in Excel

Edited screen shots showing how to import files from a database in Excel

A flash movie on importing data from an Access database after filtering

Introduction to Import or connect to data:
You can use these procedures to import data from most data sources, including OLAP databases.
1. On the Data menu, point to Import External Data, and then click Import Data.
2. Do one of the following:

Open an existing data source

a. In the Select Data Source dialog box, select a data source from My Data Sources, and then click Open.

Create a new data source connection

a. In the Select Data Source dialog box, click New Source.
b. In the Data Connection Wizard, choose a data source to connect to, and then click Next.
c. Provide the information requested by the Data Connection Wizard dialog boxes.
3.If you want, you can do the following in the Import Data dialog box:

Click Properties to choose query definition, refresh, and formatting and layout options, and then click OK.

Click Edit Query to edit the Connection, Command Type, and Command Text of your OLE DB query.

For a query created with Microsoft Query or for a Web query, click Parameters to specify how a parameter value is obtained for the external data range.

4. Do one of the following:

To return the external data to the selected worksheet, click Existing worksheet. On your worksheet, click the cell where you want to place the upper-left corner of the external data range, and then click OK.

To return the external data to a new worksheet, click New worksheet, and then click OK. Excel adds a new worksheet to your workbook and automatically puts the external data range in the upper-left corner of the new worksheet.

Importing files in Excel from an MS-Access database continued

Family Computer Club, no.9, Savitri Cinema Commercial Complex, Greater Kailash-2,
New Delhi-110048 Ph: 29213339 Mobile: 9810081867
Contact person: Dr. Dinesh K Takyar
Any Queries?
Good learning solutions!