Could use a link to sample code, and general advice, on the following.

I have a macro that imports a CSV file and then queries a SQL Server
database using criteria from the rows in the CSV file. Specifically, it uses
information from two columns and populates the row with three columns from
SQL Server if it finds a match. Right now, if there is no match then a human
has to query the database through the application's front end and key the
information into the spreadsheet by hand.

What I would like to do is have the macro do the initial matching and then
have an operator step through the missing information. I envision a form
with a couple hundred rows of data in a combobox that they'd scroll through
until they found a match. A button would insert the information into the
three columns. The form could either remain up all the time or pop us as
needed. The data in the form can remain static.

Thanks in advance for any assistance.

Forgot to mention, this is Office 2003.

"Mike" wrote in message
...
Could use a link to sample code, and general advice, on the following.