Hi,
I have been using the OLEDB VBO in Blue Prism for a few weeks, and have it successfully pulling information from one set of sheets that have a .xlsx format using the connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[File Path]&";Extended Properties=""Excel 12.0;HDR=YES;"""
However, there are also some which have a .xls format which I get an error message "Internal : Could not execute code stage because exception thrown by code stage: External table is not in the expected format." even though I have changed the connection string to:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[File Path]&";Extended Properties="Excel 8.0;HDR=YES";"
as suggested on the excel connection strings website.
I did also try just saving the files as .xlsx using the Excel VBO but this resulted in them not being able to open as the format was not matching to the data.
Thanks in advance.
I have been using the OLEDB VBO in Blue Prism for a few weeks, and have it successfully pulling information from one set of sheets that have a .xlsx format using the connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[File Path]&";Extended Properties=""Excel 12.0;HDR=YES;"""
However, there are also some which have a .xls format which I get an error message "Internal : Could not execute code stage because exception thrown by code stage: External table is not in the expected format." even though I have changed the connection string to:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[File Path]&";Extended Properties="Excel 8.0;HDR=YES";"
as suggested on the excel connection strings website.
I did also try just saving the files as .xlsx using the Excel VBO but this resulted in them not being able to open as the format was not matching to the data.
Thanks in advance.