Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Bob, Jul 28, 2006.

  1. Bob

    Bob
    Expand Collapse
    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.
     
  2. Loading...

    Similar Threads Forum Date
    Sikhconvert Joins Sikh Philosophy Network! New SPN'ers Aug 28, 2016
    Jehovah's Witnesses Are Out And Converting! Blogs Jul 31, 2016
    Islam Ishna Has Converted To Islam Interfaith Dialogues Apr 1, 2016
    A Christian Missionary tried to convert me. Blogs Oct 22, 2015
    "Convert's Corner" - Ideas for Retitle? Convert's Corner Oct 21, 2015

  3. Kernow Girl

    Kernow Girl
    Expand Collapse
    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

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

Share This Page