I wish to convert my Excel Spreadsheet contact details into an Access database. Some of the columns have repeat data, e.g. University, dormitory etc. How do I import the data into Access so that the columns with repeating data can be replaced with a drop down menu for new data, while allowing me to bulk copy-and-paste my spreadsheet data? I think I need to convert field data into a list, then take this data out of the datasheet, while allowing new data to be automatically entered in drop-down menu for future additions to the Access database.