Microsoft Excel Tips
and Tricks
Import Access Tables into Excel
You've gathered the data, now you want to analyze it. Here's
a quick way to copy an Access table into Excel.
1.
In the Access database window, click the table you want to
export.
2.
On the Standard toolbar, click Office Links.
3.
Click Analyze It with Excel.
Excel automatically opens and displays your table in a
worksheet.
|