Want to use Excel column cells as parameters to SQLSERVER query

**KWMKWM** · 08-19-2010, 01:52 PM

What I am trying to do is have an Excel Sheet with a set of values in Column A and
run a sql query using the values in column A to populate the corresponding cell on the same row in column B with an aggregrate value (MAX). Column B should contain the last active date for the part.

Please Login or Register  to view this content.

I am using Excel 2010, SQLSERVER 2008.

My procedure is as follows: On the ribbon select the DATA tab, then CONNECTIONS button, then select my procedure X from the WORKBOOK CONNECTION list, press the PROPERTIES button on the same screen. press the DEFINITION tab on the CONNECTION properties screen, change the COMMAND TYPE to 'sql' and type the
following in the COMMAND TEXT window .

Please Login or Register  to view this content.

I've tried many things where the ????? are but nothing works as far as reading
from the cell, absolute values do work, so the connection is good but that's not what I want.
Kevin

**Simon Lloyd** · 08-21-2010, 05:16 AM

Crossposted here http://www.thecodecage.com/forumz/ex...tml#post740385

**royUK** · 08-21-2010, 05:21 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this