Hi,
Need your advice in updating my database using a function like the vlookup in excel. My database consist of 1 Million + rows and one of its column (Company Name) updates more often. What I previously use in Excel is vlookup in updating my data but now I migrated my data into access and now having a problem in the naming convention.
Table 1 (In excel, I use Vlookup,$A1,Table2 Range,2,0, then copy paste the formula on the affected rows)
Old Name Production New Name
Company1 1 CompanyA
Company2 2 CompanyB
Company3 3 CompanyC
Company4 4 CompanyD
Company5 5 CompanyE
Table 2
Old Name New Name
Company1 CompanyA
Company2 CompanyB
Company3 CompanyC
Company4 CompanyD
Company5 CompanyE
Maybe you can suggest a workaround in MS access as I need to update my database on a weekly basis considering a the big no. of rows that I need to update.
Thanks,
Pabby