Can you use a cell value as a table name parameter for a SQL query?

[lobster]

I'm using MS Excel to get data from a PostgresSQL database through ODBC.

I wonder if it is possible to use a cell value to reference a table name for my queries. For example:

Code: Select all

select name from users where id=1

I'd like to get the table name "users" value from a cell in the spreadsheet.

Is this possible / easy to set up?

Thanks!

[Pinturiccio]

At the moment there is no such possibility. We will investigate the possibility to implement such feature, but there is no timeframe.

[JB.BOUCHER]

Hi,

Any update on this feature?
It would be extremly useful.

JB

[Pinturiccio]

Unfortunately, the situation didn’t change. The described feature is not supported yet, and we can't tell any timeframe when this feature will be supported.