Microsoft Excel Tips
and Tricks
Another Way to Copy Access Data into Excel
L. J. Cook of
Arkansas City,
Kansas
offered a tip on how to import Microsoft Access data into
Excel. Here's an alternative way that just requires a simple
copy and paste.
1.
In Access, open the table, query, or form that contains the
records you want to copy.
2.
On the View menu, click Datasheet View.
3.
Select the records you want to copy. Or press CTRL+A to
select the entire column.
4.
Click Copy on the File menu.
5.
Open an Excel workbook.
6.
Click the upper-left corner of the worksheet area where you
want the first field name to appear. (To ensure that the
copied records do not replace existing records, make sure
that the worksheet has no data below or to the right of the
cell you click.)
7.
Click Paste on the File menu in Excel.
|