Importing external data with cell value as input parameter

P

PADS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A data validation question 1
ODBC-Query with a parameter (by function) 0
Indirect references with VLOOKUP 5
SQL not importing records from ACCDB 2
Too few parameters error with a IIF statement 5
Query from Excel to Access - Passing Parameters? 8
Parameter Query Refresh issue 0
[Microsoft][ODBC SQL Server Driver]String data, right truncation 0

Top