Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Importing and Exporting Data
Chapter 4: Importing
and Exporting Data
In This Chapter
✓ Copying and moving data with the clipboard
✓ Importing data from other programs into Access
✓ Linking data from other programs into Access
✓ Cleaning up your imported data
✓ Exporting data from Access
✓ Collecting data though e-mails
Even if you love Access, you may not end up using it for every single
data-oriented task you need to do. Because of that, you may need to get
data from another format (such as an Excel spreadsheet) into Access. Or
you may want to take data from an Access database and use it elsewhere —
say, a statistical application, spreadsheet, or word-processing document.
But never fear — you can get data from other applications into Access. Or,
if you prefer, you can leave your data in other applications and have Access
link to it there (although you should have a really good reason to do that,
because it can get tricky).
Access provides several ways to import and export data. The rest of this
chapter covers different methods of getting data into and out of Access,
starting with the easiest method: cutting and pasting.
If you’re looking for more sophisticated methods of getting Access to share
data, such as using SharePoint and using Access as a front end for other
databases, check out Book IX.
Cutting, Copying, and Pasting
The most basic way to move information is to cut and paste (or copy and
paste) via the Windows clipboard or the Office clipboard. Cutting and
pasting is a straightforward and relatively simple way to move or copy
information into or out of Access or from one place to another within Access.