Importing and Linking Spreadsheet Files
Access can import files created by spreadsheet and related applications, such as project management systems, in the following formats:
Excel 2.x, 3.0, 4.0, 5.0, and 95 .xls files, and task and resource files created by Microsoft Project in .xls format.
Lotus 1-2-3 .wks (Release 1 and Symphony), .wk1 (Release 2), and .wk3 (Release 3 and later) files. Most spreadsheet applications can export files to at least one of these Lotus formats.
You can use OLE to embed or link charts created by Microsoft Excel and stored in files with an .xlc extension. Copy the contents of the file to the Windows Clipboard from Excel. Then choose Edit, Paste to embed or link (via OLE) the chart in fields of the OLE Object type, and ...
Get Special Edition Using Access 97, Second Edition 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.
