cosalex
01-28-2005, 08:57 AM
Dear All,
I have a list of product codes in Excel (column A) and I need for each one of them to connect to an Access database and retrieve the corresponding sales value and have it in column B.
I have tried exporting the table from Access to Excel but then the vlookup takes a long time. The opposite, importing the product codes in Access, is even harder because I have 50 worksheets where the field name is not always the same and sometimes the lookup value is in different columns.
I was looking for a query on Access that would have as criteria-input the cells of Excel where the product codes are.
TIA,
cosalex
I have a list of product codes in Excel (column A) and I need for each one of them to connect to an Access database and retrieve the corresponding sales value and have it in column B.
I have tried exporting the table from Access to Excel but then the vlookup takes a long time. The opposite, importing the product codes in Access, is even harder because I have 50 worksheets where the field name is not always the same and sometimes the lookup value is in different columns.
I was looking for a query on Access that would have as criteria-input the cells of Excel where the product codes are.
TIA,
cosalex