Import lines from Access table.

[101]

Hi , I'd like to be able to automatically populate 2 adjacent cells with information depending on what I enter into a 3rd cell.

Specifically , I would like a description and retail price to be returned depending on what part number I enter. The .mdb table I want to access has 3 columns and 252,140 rows .

I tried this with a VLOOKUP across multiple worksheets (tpasted from the access table) but the file was extremely large , it would be more efficient to pulll info as required no?

Sorry if this a n00b question

Thanks in advance.

[Trebor76]

Why not just change the existing Select query in your Access databse to a Parameter query (based on a part number) therefore restricting the set of records the query returns.

[101]

Why not just change the existing Select query in your Access databse to a Parameter query (based on a part number) therefore restricting the set of records the query returns.

Hi , and thanks for the reply. This is currently how the Access file works , the user selects a part number from the drop down list and it displays the description and price , unfortunately you can only query one part at a time. My workbook will allow the user to enter up to 20 part numbers , charged labor time
and tally the quantities for quick quoting onsite service calls.

I also only have read permission to the Access file.

[Trebor76]

You can still enter 20 parts (each one separated by a comma) in the Criteria part of the QBE grid of the relevant Select query - even if the database is read-only. You just won't be able to save it of course.