Pulling data from different data sources

[rachelimcs]

I have list of product_id in excel at local drive. I would like to pull those product_id which data table stored in database.

Looking for suggestion how to pull data for this condition where list keep in local while data stored in database.

[RW9 · Accepted solution]

Import the data from Excel, then use the dataset you create in a where clause something like:

where product_id in (select product_id from import_excel);

Without any furher information on what you have done, how you import the excel file, or how you connect to the db its hard to say.