Art Exhibitions            Index           Links           Home             Feedback

Last                                                                   Next

Community Tute 19 - Import Excel data into participant tracker

1. Start Access and open the database we created in the last tute, select the 'Tables' tab and the 'Main Table' object then hit the 'Open' button. If you did not compete the last tute you can download the database click here to download.


2. First we need to add a couple of extra fields to the 'Participants' table. Open the database select the 'Participants' table and press the 'Design' button to go into design mode.


3. Add three fields, Hospital, StartDate and StartTime, set the field types to those shown in the image below.


4. Close and save changes to the table design.


5. Time to import the Excel sheet, select 'File' > 'Get External Data' > 'Import'.


6. Choose 'Microsoft Excel (*.xls)' for the file type, select 'importparticipants.xls' and press import (or double click on the file name).


7. Select the 'First Row Contains Column Headings' check box, press the next button.


8. Choose import to a new table, we could import directly to the table but i want to show you how to use an append query to add records from the table we import to the 'Participants' table.


9. Often you have to tell access the field types on this screen but as we formatted our excel file so well this is not necessary.


10. choose no primary key as our table already has one (the ID field).


11. Final screen of the import data wizard, press the 'Finish' key.


12. Import complete without errors.


13. Open the the 'Importdata' table, it should look like the image below.





Copyright © 1999 R&D Robotics Pty Ltd, All rights reserved.
Any copyright subsisting in the above code and or literary works including source files vests with R&D Robotics Pty Ltd. ACN 086 345 137


Last                                                                   Next