O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required