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

#1 (**permalink**) 28-Jul-2006, 08:14 AM

I wish to convert my Excel Spreadsheet contact details into an Access
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10577-how-do-i-convert-repeating-excel.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10577
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.

#2 (**permalink**) 28-Jul-2006, 08:14 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10577
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10577
(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

"Bob" wrote:

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