Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple internal database query in Excel 2007 | Excel Discussion (Misc queries) | |||
Insert subtotal in a query database Excel 2007 | Excel Worksheet Functions | |||
Excel database query referencing data in the same workbook | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |