How do I convert repeating Excel column data into an Access menu .

[Guest]

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.

 

[Guest]

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 using
the columns of data and deleting duplicates. HTH Yours - Dika