How to bind variables from Excel sheet to an SQL query in Excel SQL connection with Oracle

Anonymous
2012-08-14T08:57:34+00:00

HI,

In an Excel sheet I did an Oracle SQL Connection and i need to do display the following results:

Select * From test_table where rownum < ???

Where ??? is equal to a data present in cell D4 of sheet 1.

How do i write my SQL statement inside the data connection?

THanks in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2012-08-14T10:46:50+00:00

    Hi :)

    There is a button In Connection properties - Parameters.

    Chech radio button: Get the value from the folowing cell.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-08-14T10:52:27+00:00

    Hello.

    thanks for your reply

    Can you elaborate  a bit more on where i can find this button?

    thank you very much :D

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-08-14T11:02:17+00:00

    Oki, just tell me what version in Excel you use - 2003/2007/2010/2013?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-08-14T11:04:48+00:00

    Hello

    2007

    thanks :D:D

    Was this answer helpful?

    0 comments
  5. Anonymous
    2012-08-14T11:07:40+00:00

    Data-> Connections->Properties->Definitions (Second Tab) -> Parameters...

    Was this answer helpful?

    0 comments