Results 1 to 3 of 3

Thread: LookUp from One sheet to other in Acces

  1. #1

    Post LookUp from One sheet to other in Acces



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Could anyone please help me on access to paste the sheet1 "WS data" and should use the lookup from other sheets.

    Thanks
    Attached Files Attached Files

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    143
    Articles
    0
    Excel Version
    2019
    In Access, Data is stored in tables. You will need to import your Excel worksheet into an Access table or link it. Then for your items that you need to lookup, you would build tables with your lookup values. Lookups are best done in forms. Look at this link as to why you should not do look ups from tables.

    http://access.mvps.org/access/lookupfields.htm

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,643
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Alan, this thread is one year old. Not much chance of getting an answer...
    Thank you Ken for this secure forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •