Macro version of a CTRL+F function, for thousands of results (seeking alternative)

[j.smith1981]

Hi there,

I have had soo much help from you members in the past, your help has been invaluable to me getting my employed work done, I really appreciate it!

This is why I have turned to you again.

But haha, I have another problem that I think some of you might be able to help me with.

Is there anyway of making Excel, do an SQL query in an MS access database?

Both being versions 2007, like so:

I have a macro, that downloads a CSV automatically from an FTP server every hour.

In principle, all I want it to do, is go down one column.

If a value exists, it takes that value and then searches in the Access table concerned to that function (better for OOP yea?)

It then finds multiple rows where that value exists, creates the rows by say a count procedure somehow, say 5 rows its found for product1.

It then goes in and adds in 5 rows to the excel file with the results in the next table to input the value say below that.

Is this possible?

Regards and I look forward to your advice,
Jeremy.