Bringing data into Excel directly from the database
Select Get External Data - under Data menu (if you don’t see this option you have to install more ‘stuff’ into your excel from your initial cd-rom)
Choose from available ODBC data sources - d0db
Choose from the list of tables (with excel only get the public user tables to choose from). Add the table & close the window
Under Records - you can turn off immediate fetch of the data by deselecting Automatic Query
Choose the columns you want.
Add criteria for fetching data as needed. Get data. Under File - Return Data to Microsoft Excel. If there are thousands of records - it takes a little while.
Voila - go ahead make a graph or a chart or whatever...