Built in ODBC Database Connection Missing in Quantrix 6?

3.09K viewsTips and Techniques
0

Hello,
Was looking to see if any improvements in bringing in Excel data tables and just noticed the ODBC database connection is no longer listed in Tools Option…. Is it still available in the latest Quantrix version 6?
Thanks

0

Yes – Java did drop support of ODBC which certainly impacts direct Excel connections.

Involves an extra step but export to .csv from Excel might be an option.

0

Just saw the note in the release notes.
[b:1e095ohj]Quantrix data functions (DataLink, DataNAV) no longer include ODBC support due to Java 8 dropping ODBC (QM-19963)
[/b:1e095ohj]
Will need to find an alternative way to import data… a lot of source data come from MS Spreadsheets :-(.