How to Query the Database

  • Thread starter Gunasekaran Sambandhan
  • Start date
G

Gunasekaran Sambandhan

Hi,
I am new to Excel 2007, I just analysing the following things

1. How to query the database Tables by passing the parameter from Excel
without using Macro.

Eg:
Select COl1 from Table1 Where Col1 = Excel Parameter


Please guide me on this
 

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

Access Select From External Access Database with path entered as Input parameter in query 0
problem 4
Travelling cell values with filter in Excel macro. 1
sql problem 0
Copy/Paste Special from Many Files 2
Query from Access Database based on user selected parameters in Excel 2
pass parameter to Query 3
Calling SQL from code has different behaviour than calling it from MS SQL Server Management Studio 1

Top