I have several shared Excel files that I'd like to query across a network. I've clicked Data- Import Data and followed the Wizard, but keep getting an alert stating that the file could not be decrypted with a heading of 'ODBC Excel Driver Login failed'. Is it possible to query shared files or am I missing a driver on my system or something? Thanks in advance.
Edit: I can query existing (unshared) workbooks with no problem, so it looks like it's an issue with shared workbooks.
This message was edited by Mudface on 2002-10-21 04:30
Edit: I can query existing (unshared) workbooks with no problem, so it looks like it's an issue with shared workbooks.
This message was edited by Mudface on 2002-10-21 04:30