TAP6 Facility Import (Excel)
Q: How can I import an Excel spreadsheet into the Fixed Facility database?
A: You can import an Excel (.XLS) or comma-delimited ASCII (.CSV) file into the TAP Fixed Facility database by saving the file as a dBase IV (.dbf) file.
For example, suppose you have an Excel file that contains the required Fixed Facility fields for import:
In the Excel menu, click File and select SaveAs. The SaveAs dialog box is displayed:
Use the “Save as Type” list near the bottom of the form to select “DBF 4” and click the Save button.
A warning message will be displayed about the differences in the file format. Since we want to save in the dBase format, click the Yes button.
The file will be saved as a .dbf file that can be imported into the Fixed Facility database.
 |
Copyright 2006 by SoftWright LLC