Is there a possibility to read and use data from a .SQL database in My excel sheet?

[Sem1]

I'm trying to make a new Excel workbook that can communicate or take information out of an sql database, I want the following to happen:

In the excel sheet I type a number (client id) that corresponds with a number (client id) in the database. This client id has some information like: name, address, postal code etc.

I'm looking for a possibility where I type the client id in my Excel sheet and it will output all the client information from the database in my excel sheet

I'm quite new to excel so I was wondering if this is even possible? If yes, what is the best way to do this?

Things I already tried are the "External Data Source" -> "Database" button. But that way I couldn't really find out how to connect to the database.

Thanks in advance!

[pjwhitfield]

There was a thread earlier about using Access databases in Excel > http://www.excelforum.com/excel-prog...ml#post3923757

The 2st part of my answer is how to connect and return the query, this should only need minor tweeks (I believe) to use an SQL database rather than Access.