October 1997
Intermediate to advanced
1312 pages
38h 56m
English
A primary use for filters and customized datasheets is for exporting the filtered records to another application, such as Microsoft Excel or Word. A variety of methods for exporting filtered and custom-formatted records is available:
▸▸ See Exporting Data from Access Tables
Copy the entire datasheet to the Clipboard, and then paste it into the other application. Hidden columns don't appear, but formatting (font, font attributes, and row height) is preserved.
Use the Save As/Export feature to export the datasheet to an Excel worksheet (.xls) or a Rich Text Format (.rtf) file for Word or other Windows word processing applications. (Choose File, Save As/Export, select To an External File or ...
Read now
Unlock full access