Create reports in excel using ODBClink
With ODBClink, creating reports in Microsoft Excel is simple.
- Configure your data warehouses to pull the data you need;
- Create an ODBC DSN to your data warehouses;
- Use Microsoft Excel’s native Query Tables and Pivot Tabels functionality to pull your data into Excel and format your reports as you desire.