Is anyone aware if its possible to connect Excel to an IMD file using ODBC - ie the IMD file is the source.
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.
Thank you so much Brian!!! Works with Excel perfectly. Im going to also look at Power BI based on your comment
IDEA is a trademark of CaseWare International Inc., used by permission.
All material provided on the IDEAScripting website is presented as is without any warranty or guarantee. Anybody using any solution provided on this pages is encouraged to validate the effectiveness and reliability on their own.
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories