can anyone please tell me what I have to do on my laptop to be able to establish an ODBC connection to an Excel file?
The file is encrypted, I know the password, but I cannot pass it to QlikView in a regular LOAD - but I have heard from @flipside that it should be possible using an ODBC connection.
That is not possible as yet - so i guess there is a driver missing or something. Unfortunately the guy from IT who was supposed to do this seems to know just as much about it as I do 😉 The difference is only that he would have the admin_rights required to do whatever he would have to do if he knew ...
- When I select "ODBC" in the scrript_editor right away, that list is blank, I cannot do anything.
- When I select "OLE DB" and then "OLE DB for ODBC drivers", I can click a bit further, but when I choose to build a connection_string and then select the tab "machine data source" and "Excel file", I get an error message.
I guess I cannot do it because I don't have admin_rights on this laptop.
Anyway - could anyone describe what would have to be done once I have someone from IT here with me to do it?
Thanks a lot!
P.S.: Needless to say, I need a way that someone from IT can set this up (with admin_privileges) and I can then use it (without admin_privileges).