Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to load a data from an excel file, that have a password. I trid different tips to load the data, but the only way that works for the moment is if I load the data with ODBC when the Excel file is already open in Excel. If the excel file isn't open in Excel, I'have the following errors.
Did anyone know a way to load Excel file with password?
Thanks
Hello Lucas,
Does this problem happen with all other excel files, meaning files which do not have a password?
What is the contents of the file? Is it possible for you to upload a sample of the file for me to try with?
Thanks,
Mark
Try to link excel file from Relative path, does it work?
If not then please provide the sample of .xlsx file.
There's no problem with file that don't been protected by a password.
If the document is already open in local, the loading work corretly but we don't want to have to open this document before loading.
For the document, i'have to make some modification in the file before send it because it's a file that come from a client.
I will update it when i can.
Thanks for the answer