Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a spreadsheet that contains a part number, description, and price for parts. Essentially it's a customer quote. In an MS Access database ( which has 78K rows, too large to import into excel ) resides the same information, but along with it an "internal" part number. What I need to do is this : read the list of part numbers in excel, look them up in the database, and return me the "internal" part number, placing it in a column next to the "external" part number in the spreadsheet. Something like a vlookup command but from a Access database instead of another spreadsheet. Any ideas ? Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
When opening Excel - get Access (Read-Only) file and error | Setting up and Configuration of Excel | |||
In EXCEL, access denied when deleting read only | Excel Discussion (Misc queries) | |||
i cannot open excel file error Cannot access read-only document me | Excel Worksheet Functions | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions |