Create reports in excel using ODBClink

With ODBClink, creating reports in Microsoft Excel is simple.

  1. Configure your data warehouses to pull the data you need;
  2. Create an ODBC DSN to your data warehouses;
  3. Use Microsoft Excel’s native Query Tables and Pivot Tabels functionality to pull your data into Excel and format your reports as you desire.