Page 1 of 1
ODBC connection to EXCEL
Posted: Fri Aug 14, 2020 6:43 am
by roei61
Hi All,
I'm trying to set ODBC connection to xlsx.
I get no results (there are in the Excel) just blank column F1
Thanks
Roei
Re: ODBC connection to EXCEL
Posted: Fri Aug 14, 2020 12:31 pm
by tomok
Do you have the 64-bit ODBC driver for Excel installed on the TM1 server?
Re: ODBC connection to EXCEL
Posted: Wed Aug 19, 2020 4:27 pm
by roei61
Hi,
My Excel in the server is 32Bit and I cannot change the installation.
I don't think I'll be able to install 62bit ODBC driver if my Excel is 32
Re: ODBC connection to EXCEL
Posted: Wed Aug 19, 2020 6:06 pm
by tomok
roei61 wrote: ↑Wed Aug 19, 2020 4:27 pm
Hi,
My Excel in the server is 32Bit and I cannot change the installation.
I don't think I'll be able to install 62bit ODBC driver if my Excel is 32
Then you won't be able to do what you asked about.
Re: ODBC connection to EXCEL
Posted: Thu Aug 20, 2020 7:59 am
by David Usherwood
Perhaps look at this?
https://code.cubewise.com/odbc-connect
Also, I recall this from earlier releases. Can't say whether it survived in TM1 11/PA:
https://www.ibm.com/support/knowledgece ... proxy.html