LookUp from One sheet to other in Acces

[aravindkm]

Hi,

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

Thanks

[alansidman]

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]

Alan, this thread is one year old. Not much chance of getting an answer...