Download instructions for Aircraft Register
The following instructions are provided as a guide only to down loading the
Aircraft Register to a disk and loading the data into an Access database. It is
recommended that, if help is required, you print these instructions before commencing.
To download the civil register
- Click on the file to down load
- Select 'File' option from menu bar at the top of the page
- Select 'Save As'
- Select appropriate drive from pull down menu in 'Save in' dialogue box
- Give the file a name (if a default name has appeared, you can leave this as the title,
if preferred)
- Click on the pull down menu in 'Save as type' dialogue box and select 'Text'
- Click on the save button
- The file will save - after saving is completed click on 'Back' button
- The information can now be read from the disk or loaded into a data base (eg Access,
Excel)
To load the information into MS Access
- Open Access data base
- Select 'Blank Database' in the 'Create a New Database Using' dialogue box
- Click 'OK'
- Select appropriate Drive in the 'Save In' dialogue box (this should be the drive in
which you wish to save the database you are about to create)
- Enter a name in the 'File name' dialogue box (eg Aircraft Register)
- Use the pull down menu in the 'Save as Type' dialogue box and choose 'All Files'
- Click on 'Create' - you now have a blank database - a dialogue box will come up with the
heading you have given (eg Aircraft Register : Database).
- Open the 'Tables' option
- Select 'File' option from the menu bar at the top of the page
- Hold the mouse over 'Get External Data' - this will bring up another option box
- Select 'Import'
- Select the file you wish to import by clicking on it. The 'file of types' should be
selected as 'Text'.
- Click on 'Import'
- Text Import Wizard should now come up to help you load the data base
- In the first dialogue box select the 'delimited' option. Select 'Next'
- Select 'comma' as the delimiter that separates the fields. Check on first row contains
Field names. Select 'Next'
- Select the appropriate table to store your data (eg In a New Table). Select 'Next'
- import the table, select 'Finish'
- When the information is correctly imported into your database you will receive message
'Finished importing.............. Select OK.
To load the information into MS Excel
- Open Excel
- Select 'File' option from the menu bar at the top of the page and click on Open
- Select the file you wish to import by clicking on it. The 'file of types' should be
selected as 'Text'.
- Click on 'Open'
- Text Import Wizard should now come up to help you load the information
- In the first dialogue box select the 'delimited' option. Select 'Next'
- Select 'comma' as the delimiter that separates the fields. Select 'Next'
- To import the information, select 'Finish'
- Format 'datereg' cell to date. (Datereg is a date
field)
Note : The first row of the file would contain the headings of the field to which they
relate.