This is a short introduction on how to connect DataVirtuality Server to MS Excel via an ODBC connection. It is important that you use matching Excel and driver.
For example if you have installed the 64 Bit ODBC driver, then you need to have a 64 Bit Excel. Otherwise it will not work.
The Excel which was used to take the snapshots was in german.
- click on data
- click on other source
- then for example "Microsoft query"
- choose the correct ODBC driver and click "ok"