O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

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

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

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