Can you vlookup from excel to access

I have an Excel worksheet where users enter a list of part numbers. They also need to enter the description of the part numbers. Some of these part numbers already exist in a Access database and to make life easier for the users it would be nice if we could use the VLOOKUP function to find the descriptions of the part numbers in the database and populate the worksheet.

Our database is an MDE file which links back to a part number table. I am unable to bring the part number data from the data base to excel due to the list of part numbers is nearing K. Any help will be greatly appreciated. As I understand you want know how to use the Vlookup function to access the data from other data sources. Let me assist you with the issue. Was this reply helpful? Yes No. Active 5 years ago.

Viewed 2k times. Improve this question. Amarantamin Amarantamin 1 1 1 bronze badge. I am not sure where to start. I have searched for referencing Access from Excel and find information on importing tables, but I don't need whole tables of data.

If there is a similar command for referencing Access, I could start there. Have you tried Dlookup? Add a comment. Active Oldest Votes. Hope this helps. Improve this answer. Percy X Percy X 1 3 3 bronze badges.

You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Thread starter Pinball Start date Apr 17, Pinball Board Regular.

Joined Apr 18, Messages Reason I need to do this in Excel is because the users are not at all familar with Access and want to keep using Excel. Thanks much. Excel Facts. Spell Check in Excel. Click here to reveal answer. Press F7 to start spell check in Excel.

Be careful, by default, Excel does not check Capitalized Werds whoops. Mark W. MrExcel MVP. Joined Feb 10, Messages 11, No, you'd need to write a query. Joined Apr 29, Messages 6, You may need to change the path to match ' where Microsoft Office is installed.

Set the QueryDef object parameters. Execute the QueryDef. OpenRecordset ' 6. MoveLast Rs. MoveFirst ' 7. Set up a loop that will modify each record in the recordset. RecordCount Rs. Update Rs. Tags: MS Access. Anonymous September 10, 0 Comments. LadyRaeshal, The differences between Excel and Access are sufficiently great that the equivalent arrangements are different for different contexts.

Michael S. Anonymous Posted September 10, 0 Comments. Register or Login. Welcome back! Reset Your Password We'll send an email with a link to reset your password.

Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign in with email Enter the email address associated with your account.