MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Trudy on April 20, 2000 11:44 AM

Any way to reference an access database file utilizing Vlookup in Excel 97

Posted by Tom Morales on April 21, 2000 6:22 AM

Trudy - I beleive you're going to have to pull the Access data into Excel, first. (Data/Get External Data/Create New Query.) Once you've set up the Access data on your worksheet, you can refresh the query's data periodically, either manually, or by macro (say, on the opening of the worksheet).