Microsoft Excel Tips
and Tricks
Import Access Data into Excel
Did you know you could import data from your Microsoft
Access databases into Microsoft Excel? Here’s a quick and
easy way to do it:
1.
Open the Excel workbook into which you want to import the
data.
2.
On the Data menu, point to Import External Data,
and then click Import Data.
3.
In the Select Data Source dialog box, click New
Source.
4.
In the Data Connection Wizard dialog box, click
ODBC DSN, and then click Next.
5.
Click MS Access Database, and then click Next.
6.
In the Select Database dialog box, browse to the
database file you want to import, and then click OK.
7.
In the Data Connection Wizard dialog box, click the
name of the table that contains the data you want to import,
and then click Next.
8.
Type a name and description, and click Finish.
9.
In the Select Data Source dialog box, click the data
source you just created and then click Open.
10.
In the Import Data dialog box, specify where you want
to put the data, and then click OK. (While the
Import Data dialog box is open, you can click the row on
your spreadsheet where you want the data to appear and the
Existing worksheet box will update automatically with
the correct information.)
|