This is a short introduction on how to connect Data Virtuality 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"