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

B

Bob

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.
 
K

Kernow Girl

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top