P0lar
Member
Hi,
I had a lovely macro which extracted data from one of our systems via ODBC. I was then upgraded my laptop to 64 bit Windows but kept 32 bit Excel and the connections have broken. Our IT team refuse to back out the change as 64 bit is the future... I've set up a new ODBC driver in sysWOW32 which tests successfully but I can't get excel to reference this when I try to connect to external data as it only sees the 64Bit connections list.
Help!
I had a lovely macro which extracted data from one of our systems via ODBC. I was then upgraded my laptop to 64 bit Windows but kept 32 bit Excel and the connections have broken. Our IT team refuse to back out the change as 64 bit is the future... I've set up a new ODBC driver in sysWOW32 which tests successfully but I can't get excel to reference this when I try to connect to external data as it only sees the 64Bit connections list.
Help!