Import or link files in Lotus 123 .wkx format, and later supported in Microsoft Office as an import/export format. Lotus was a spreadsheet program, like Excel, and not a database. Many people nonetheless used Lotus as an ad hoc, small database application.
Manifold uses Microsoft facilities to
connect to all Microsoft Office formats, including .wkx,
and other legacy Office formats such as .db,
.html, .mdb,
and .xls, together with
newer Office formats such as .xlsx
and .accdb. If Manifold
cannot import from .xls
or .xlsx, that means the Windows
system we are using is missing the necessary facilities. Please
see the Microsoft
Office Formats - MDB, XLS and Friends topic for a solution.
Important: When importing a WKx file the tables and queries that appear in the Manifold project are Manifold components with no further connection to the WKx file from which they were imported.
Choose File-Import from the main menu.
In the Import dialog browse to the folder containing the .wkx file.
Double-click the .wkx file desired.
Everything found in that .wkx file will be imported into the project.
This particular .wkx file contains a single table.
If a table from the .wkx is
not created as shown above,
that means the Windows system we are using is missing facilities necessary
for a connection to .wkx. Please
see the Microsoft
Office Formats - MDB, XLS and Friends topic for a solution.
We can double-click the table to open it.
The lotus1: table contains values for the cells that were in that worksheet. Manifold imports the table as is, not adding any index since there was no index in the Lotus file (Lotus was a spreadsheet and not a database). To make the table fully editable and selectable we must add an index, as illustrated in the Add an Index to a Table topic.
Important: When linking a WKx file the tables and queries that appear in that data source in the Manifold project stay resident in the WKx file. They are WKx components even though they may appear in many respects, for the convenience of the user, to be Manifold components. WKx files linked into a Manifold project are read only.
The Save cache button allows setting cache options. Most often when linking to a format like WKx, we will ensure the Save cached box is not checked. Working with a linked WKx file would, in theory, be faster if we check the box, but WKx files tend to be very small so operations are fast anyway. If we are going to cache data within the project we may as well simply import the WKx and use full Manifold speed. We uncheck the box and then we press Link.
To link a WKx format file:
Choose File-Link from the main menu.
In the Link dialog browse to the folder containing the .wkx file.
Click the .wkx file desired.
Check or uncheck the Save cache box as desired.
Press Link. A linked data source will appear in the project.
Press the + icon next to the data source to expand the data source to see the tables it contains.
That creates a data source called lotus1 that contains all of the tables in the .wkx file.
If a new data source for the .wkx is
not created as shown above
that means the Windows system we are using is missing the facilities necessary
for a connection to .wkx. Please
see the Microsoft
Office Formats - MDB, XLS and Friends topic for a solution.
We can click on the + icon by the data source cylinder to expand the lotus1 hierarchy. In this example, the hierarchy contains only the lotus1: table plus two system tables that seem to appear courtesy of Manifold's internal functioning.
Opening the lotus1: table we see it is the same table that was imported earlier in this topic. Since it is linked the table is still resident in the .wkx file. The table is read-only since we cannot add an index to the table (no indexes in Lotus format).
UUID - PostgreSQL, Jet DB, Jet WKx, Jet XLS, and ADO.NET databases support UUID fields as a native UUID type.
File - Create - New Data Source
Microsoft Office Formats - MDB, XLS and Friends