ODBC with imd file as the source

3 posts / 0 new
Last post
raoul.kelly
Offline
Joined: 08/13/2019 - 07:12
ODBC with imd file as the source

Is anyone aware if its possible to connect Excel to an IMD file using ODBC -  ie the IMD file is the source.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Raoul,

If you have 10.3 or later you should be able to do this as IDEA now as ODBC driver.  In 10.4 they are pre-installed when you install IDEA and 10.3 they are a separate download.  You would then have to configure the ODBC driver to point at a project folder and then you should be able to access it through Excel.  I have never tried it with Excel but I have used it with Power BI.

Brian

raoul.kelly
Offline
Joined: 08/13/2019 - 07:12

Thank you so much Brian!!!  Works with Excel perfectly.  Im going to also look at Power BI based on your comment