Hi Bob - actually it's easy. Import your data as is, then create the
Table(s)you'll use for your Lookup Tables and enter your data into them
(University, dormitory, etc.) and set the link to the Lookup from the 'main'
DB. Don't set to Limit to List till you check that it's all spelled
correctly. I've done this several times and not had a problem and even
imported the same data several times to set up my Lookup Tables, just usingReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10577-how-do-i-convert-repeating-excel.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10577
the columns of data and deleting duplicates. HTH Yours - Dika
> I wish to convert my Excel Spreadsheet contact details into an Access
> database. Some of the columns have repeat data, e.g. University, dormitory
> 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.