I am in the process of building a table on Access 97 where one column will have a list of various buildings. The problem is I will need to import a spreadsheet from Excel 97 into the Table, and although the spreadsheet will match the Access table in terms of column headings, it's data is numerical ie a number has been assigned for each buliding instead of the building name. I need the Access table to show the building name instead of the number.

Is there a validation rule I could use when creating the Access table where a number will = a specific building name. ie 1= Lunar House 2= Apollo House 3 = Mackenzie House etc. So when it does come to importing my spreadsheet the numbers will show as buildings.

Hope you can help....many thanks

Russell from UK

use a look up table where the number is the primary key and a name field for the builing name. Do not input directly into a table

Tables - store data
Forms - Enter Data

thankyou I will give this a go :)


use a look up table where the number is the primary key and a name field for the builing name. Do not input directly into a table

Tables - store data
Forms - Enter Data