Excel Connection with Access database

[ymcontractor]

The scenario is that Column A is an input column and a user input Product ID's in multiple rows in that column.

I need to create a macro where Excel connects to Access database that has the Product details (like - Price, description, hierarchy) in a table.

When the macro is hit the Product ID's (multiple id's from each row) is passed as a parameter every-time and the Product information is returned in Excel sheet against each product ID.

Any help is appreciated. Thanks

[dflak]

Maybe this article can help. http://www.utteraccess.com/wiki/MS_Query.

To help you some more, I'd need to know more about your requirement.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.