View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abel MacAdam Abel MacAdam is offline
external usenet poster
 
Posts: 10
Default (Excel 2007) Query Data in Database?

Hi all,

I want to query data in a database in Excel. And I'm not exactly (actually
exactly not) sure how to get it done.

I opened the Data part of the buttons thingy, choose 'Get external data',
and next 'From other Sources'. I filled in the required information (like
database location, and username and password combination). In the next window
I selected a table, and the end result was that I imported the complete
table. And that is not what I was aiming on.

What I wanted to accomplish was to write a query using SQL. I have the query
available. What I now have to do is find the window where I can enter the
query. Do you know?

Abel