How to Convert a file from Supercalc 5 to Access for Office 95
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 Comma Seperated Value file. Use the commands //E for export, arrow to the right for csv. When prompted for the filename enter c:\sc5files\filename.csv (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 95
Start Access and Open the Address database.
To import the csv 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 Text files (*.txt, *.asc, *.csv).
Change the "Look-in" box to the C: drive, then double-click the SC5Files folder.
Select the file filename.csv
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 December 7, 1998
Ellen R. Doyle, Information Technology Specialist, ACES CTU
