Querying database in Excel
Querying database in Excel
(OP)
I am working in designing a query tool for a flat file, and want to get any suggestions. I have a database spreadsheet with three fields, say country, product and sales. And I want to show summarized tables of this data. Is there a straight forward way to do this using combo boxes? I know about pivot tables, but the issue with them, for example is handling year-over-year growth rates, among other things.
Thanks for your advice.
Jota
Thanks for your advice.
Jota





RE: Querying database in Excel
Bill
RE: Querying database in Excel
Its an easy for me in access compared to excel but that is due to my preference for access. I'd be glad to help if I can.
Good day
G Austin
Gerald Austin
Iuka, Mississippi
http://www.weldinginspectionsvcs.com
RE: Querying database in Excel
Thanks for your suggestion. Unfortunately, I am designing this as a deliverable for some of the internal customers, and the issue with access is that yu need to have the application to run any queries. Unfortunately, not everybody has Access on its computer, so I might stick to Excel. Thanks again.
Bill:
I think I am gonna try your suggestion instead. I recorded a macro and got the basic coding in VBA to query the data. I will see what is the best way to program the inputs using ComboBoxes.
Regards,
Jota
RE: Querying database in Excel
With MS Query you can retrieve data from an Access.MDB to Excel without having Access installed on the client machine.
You can open MS Query as a stand alone program to view and edit Database information or configure a query. Just make a link to the EXE in your MS Office folder.
"C:\Program Files\Microsoft Office\Office\MSQRY32.EXE"
With Excel Visual Basic you can run DAO or ADO directly from Excel and return the results to a spreadsheet. With DAO you will have to set the 'Microsoft DAO 3.6 Object Library' in the References attached to your Workbook to have the functionality.
Bill
RE: Querying database in Excel
Bill