For each Row query SQL...

[tonyroo]

Hi there,

I have been searching for hours this morning and perhaps my search query is not correct however I can't seem to find the answer I am looking for.

The hope is to have an excel worksheet that retrieves from a SQL connection on a row by row basis. So for example in Column A I would have a "Job No." and then column B would be the job status and column C would be the current job PM, but column A would be hand typed in and column B and C would be retrieved from the database.

I can create a SQL Query and add a parameter to it however I can't make it row dependent.


Sorry if this has been asked before, any help is greatly appreciated.

t

[shyamhappy]

Have you used Activex Data Objects Library to connect to the data base.

Once data entering is completed in the A column then Connect to data base, Retrieve data from Table and insert in the columns in the B and C.

Please let me know if you need some more info.

________________________________________________________________________________________________________________________________________
Please click * to add reputation if this answer has helped

“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison

[tonyroo]

Thanks. I'll give it a try.

t

[Norie]

Why not import the entire table into Excel?

Then you could use VLOOKUP or other formulas to pull the job status and current job from the import based on what's entered in column A.