Link Excel to Access
I have a database that has part numbers, location, and description.
There is thousands.
I want to have a speadsheet where I can type in 10 part numbers (A1 - A10)
I want column B and C to autofill with the data pulled from Acess.
Is this possible?
|