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
ODBC connection to EXCEL
-
roei61
- Posts: 41
- Joined: Wed Aug 22, 2012 5:44 am
- OLAP Product: PAX
- Version: 2.0.7
- Excel Version: 2016
- Location: Israel
ODBC connection to EXCEL
- Attachments
-
- 1.PNG (14.04 KiB) Viewed 2434 times
-
tomok
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: ODBC connection to EXCEL
Do you have the 64-bit ODBC driver for Excel installed on the TM1 server?
-
roei61
- Posts: 41
- Joined: Wed Aug 22, 2012 5:44 am
- OLAP Product: PAX
- Version: 2.0.7
- Excel Version: 2016
- Location: Israel
Re: ODBC connection to EXCEL
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
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
-
tomok
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: ODBC connection to EXCEL
Then you won't be able to do what you asked about.
-
David Usherwood
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: ODBC connection to EXCEL
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
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