Import lines from Access table.

**101** · 01-31-2007, 07:38 PM

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** · 01-31-2007, 08:42 PM

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** · 01-31-2007, 09:18 PM

Originally Posted by 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.

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** · 01-31-2007, 10:18 PM

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.

Import lines from Access table.

LinkBack

Thread Tools

Rate This Thread

Display

Import lines from Access table.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions