| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 42264 | 2004-02-06 00:22:00 | Excel Database Query Addin | me_ill (5233) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 213092 | 2004-02-06 00:22:00 | I'm looking for an a function Excel that enables me to dynamically query a database for data from one cell using parameters a little like Hyperion or how DSum etc work in Access I want to look at some reporting using Excel as a front end tool and Access or something else as a backend and find the "database" paradigm used within Excel to be limited and fankly not useful (a table of values is not really a database. |
me_ill (5233) | ||
| 213093 | 2004-02-06 01:39:00 | > (a table of values is not really a database. Exactly the reason why Excel is a Spreadsheet program (a lot of tables of values) rather than a database. Mike. |
Mike (15) | ||
| 213094 | 2004-02-06 02:32:00 | Ahhh but it is much better than a database for producing summary KPI reports etc and way better than word. | me_ill (5233) | ||
| 213095 | 2004-02-06 07:38:00 | Hi, you can grab data from an external source such as an Access database (table or query) by selecting Data|Import External|New Database Query from the menu. See Importing Data in the help for more info. | parry (27) | ||
| 213096 | 2004-02-06 08:07:00 | Yep that's the traditional "clunky" way but I really want to be able to use a function providing the table and some variables to return a summary a little like Dsum works in Access. I've seen it used for Hyperion Accpac and some other Accounting packages for report writing but I have not been able to find something more general. |
me_ill (5233) | ||
| 213097 | 2004-02-06 09:00:00 | Isnt that what a query is?? XL also Dsum as well but you could write some SQL in XL VBA and grab the result but if you just want a total why bother with XL. Hard to know what you want as Im not familiar with accounting packages. | parry (27) | ||
| 213098 | 2004-02-06 19:57:00 | Duuuuuuuuuuh ah a problem shared is a problem solved. Why not write a function in VB the part I had overlooked was using a SQL to get my data. Thanks |
me_ill (5233) | ||
| 1 | |||||