Devart Forums

Posted: **Thu 20 Oct 2016 22:54**

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!

Posted: **Fri 21 Oct 2016 14:21**

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

Posted: **Tue 04 Jul 2017 16:44**

Hi,

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

JB

Posted: **Wed 05 Jul 2017 12:04**

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.

Devart Forums

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

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

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

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

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