Re: Excel validation.

That does work, I use it all the time.
I also make the use a parameter in the SQL and link it to a cell in
excel and when that value changes it can automatically refresh the
data.

The way to do that is to click add criteria and slect your column and
for your value type in [?]

For example, this SQL uses IBM sample customer file included in
library ADTSLAB.
You could just copy and paste this by pressing SQL button.

SELECT CUSTOMER.CUSTNO, CUSTOMER.CUSTNA, CUSTOMER.REPNO,
CUSTOMER.CONTAC, CUSTOMER.CPHONE, CUSTOMER.CFAX, CUSTOMER.CADDR,
CUSTOMER.CCITY, CUSTOMER.CCOUNT, CUSTOMER.CZIP, CUSTOMER.CZIPLO
FROM ADTSLAB.CUSTOMER CUSTOMER
WHERE (CUSTOMER.CUSTNO=?)

When you click return data to Ms Excel click the parameters button and
select "Get the value from the following cell" and select the cell and
you might want to check the "Refresh automatically when cell value
changes"

-----
Bill

On Jun 7, 6:28 pm, "Saml" <none@xxxxxxxxxxxxxxx> wrote:
This may work: Configure an ODBC connection. Start Excel. Click menu
Data/Import External Data/New Database Query using your new ODBC connection.
Then write the SQL necessary to get your one record.

Sam

<I_am_f...@xxxxxxxxxxx> wrote in message

news:1181236117.328201.202220@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi,

Is there a simple way of retreiving a single record from DB2 file with
Excel based on row/column value.

Thanks.


.

Relevant Pages

  • RE: new to excel...
    ... each cell which makes your data ... back TRUE, your date - even though it looks like a number, is viewed by Excel ... open up the spreadsheet that has your pasted sql data. ... > of a survey from which I need to do summaries and charts. ...
    (microsoft.public.excel.newusers)
  • Imbed SQL in Excel ?
    ... I would prefer to do this by entering the SQL into a cell, ... a little lost in Excel ... lot better than I know Excel's lookup functions. ...
    (microsoft.public.excel.programming)
  • INDIRECT(ADDRESS) inside a VLOOKUP
    ... out to an Excel file via SQL statements. ... <this is cell B2> ... Second Evaluation: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: INDIRECT(ADDRESS) inside a VLOOKUP
    ... out to an Excel file via SQL statements. ... <this is cell B2> ... Second Evaluation: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Syntax for Excel variable using a SQL Select/From/Where Command...
    ... Dim SQL As String ... Microsoft MVP - Excel ... www.cpearson.com "Mark D." ... > What is the proper syntax for using the contents of an Excel> cell in an SQL ...
    (microsoft.public.excel.programming)