Other Ways to Share Access Data
All the methods of importing and exporting data described in this chapter work well, but they aren’t the only ways to share information with other programs.
Sometimes the quickest and easiest way to get information into or out of a database is to just copy it and paste it where you want it. This technique works particularly well for getting data out of an Access table and into Word or Excel. If you paste into Word, the data becomes a Word table, complete with a header row containing the field captions as column headings. If you paste into Excel, the data is displayed in the normal row-and-column format on the worksheet.
Getting data into an Access table by using this technique is a little more complicated. The data ...
Get Microsoft® Office Access 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
