ExcelBanter - Importing external data with cell value as input parameter

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Importing external data with cell value as input parameter (https://www.excelbanter.com/new-users-excel/204874-importing-external-data-cell-value-input-parameter.html)

PADS

Importing external data with cell value as input parameter

Hi ,

I need a query database with excel value say as A1 as input parameter and
return the query value in cell B1.Tried with Data--Connections.The
connection DB is oracle and the excel verion is 2007.How can i pass the cell
value to SQL statement?

Thanks,
PADS

All times are GMT +1. The time now is 07:05 AM.