How to Convert a file from Supercalc 5 to Access for Office 97
Step 1: Export a SuperCalc 5 File
Start Supercalc 5, open your address file.
In the first row of your data file, you have headings. Make sure headings are one word, less than ten characters in length and have no periods or slashes in the name.
In Supercalc 5, Export your address file as a dBase file. Use the commands //E for export, arrow to the right for dbase. When prompted for the filename enter c:\sc5files\filename.dbf (you can press enter to accept the default name and extension).
Quit Supercalc.
Step 2: Create an Access Database for Addresses
Click Start, MS Office, Access.
To create a new database, choose "blank database".
At the prompt, type a filename. For example, use a general name like the filename "Addresses" and the folder location is "My Documents" (you may change the folder location by changing the folder listed in the "Look-in" box.
Click Create.
Next, you may create a new table or import data.
Note: An Access database can have several tables in a single database file.
Step 3: Import data as a new Table in Access - Office 97
In Access, Open the Address database (if it is not already opened).
To import the dBase file as a new table, click on the Table tab, then click on the File menu, Get External data, Import.
At the Open dialog box, change the Files of Type to dBase III (*.dbf). Select the file c:\sc5files\filename.dbf
Click Import.
Next you will see the Import Wizard. Click Next.
Check the box for "First Row Contains Field names". Click Next.
Click Finish.
You will be given the prompt of a successful import, Click OK
Click Close (unless you have more tables to import).
You will then see the list of tables available in your database.
Note: One SuperCalc file is now one table in the Address Database, you can add more tables (old Supercalc files) to the same database.
Last Modified on September 17, 1998
Ellen R. Doyle, Information Technology Specialist, ACES CTU
