# Connecting Excel via ODBC

**URL:** <https://community.cdata.com/t/connecting-excel-via-odbc/832>\
**Category:** CData Virtuality \[Archived\]\
**Tags:** article, cdata-virtuality\
**Created:** [July 12, 2024, 4:28pm UTC](https://community.cdata.com/t/connecting-excel-via-odbc/832 "2024-07-12T16:28:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anonymous](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anonymous](https://community.cdata.com/u/anonymous)\
**Post date:** [July 12, 2024, 4:28pm UTC](https://community.cdata.com/t/connecting-excel-via-odbc/832/1 "2024-07-12T16:28:54Z")

</div>

This is a short introduction on how to connect Data Virtuality Server to MS Excel via an ODBC connection. It is important to 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.

To connect Data Virtuality Server to MS Excel via ODBC, please do the following:

- Click “Data”;
- Click “Other source”;
- Click “Microsoft query” for example:

 ![mceclip0.png](https://us1.discourse-cdn.com/cdata/original/2X/6/67a7a3a11010f57d24884daf691f669fcc8f30d9.png)

- Choose the correct ODBC driver and click “OK”:

 ![mceclip1.png](https://us1.discourse-cdn.com/cdata/original/1X/b002977c39bd90809d9aa29063a67d7371a90413.png)