PDA

View Full Version : LookUp from One sheet to other in Acces



aravindkm
2017-09-24, 08:50 AM
Hi,

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

Thanks

alansidman
2018-10-01, 05:52 PM
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

Pecoflyer
2018-10-01, 06:14 PM
Alan, this thread is one year old. Not much chance of getting an answer...