Trying to read excel file OLEDB object

[PrateekMehan]

Hi, When I try to configure OLEDB object to read data from a heavily loaded excel I get the following error : "Internal : Could not execute code stage because exception thrown by code stage: Unrecognized database format 'C:\Users\213348324\Desktop\Technical Evaluation.xlsx'." Also when I referred the document for OLEDB it says set connection has four inputs: User name, Password, Provider, Connection String. But going through my BP VBO I don't find the "connection string " input. Please assist any advice /suggestion would be appreciated. Thanks In advance.

[Anonymous]

Hey, That's a exemplary connection string ""Provider=[variable];Data Source=[variable];Persist Security Info=True"" You provide arguments to create it. You dont provide connection string to a connection string ;) That's why in BP VBO you are missing connection string input.

[PrateekMehan]

hi, but at my end I probably tried everything and still the error remains same I am not able to fetch data from the heavily loaded excel error says ""not a valid database format

[polinenileela_b]

Hi Prateek , In Database give your data base name , Provider u can give ""MSDAORA"" or ""MSDAORA.1"" user Id and password are your credentials hope it helps.. Thanks

[Anonymous]

Hi, If you still have problem, go to ""https://www.connectionstrings.com/" There is plenty of connection strings 😉

[PrateekMehan]

I am trying to read an excel so my database here is the excel file. And if you have a look at the new OLEDB object it doesn't have a connection string input, I hope u didn't get my question Anyways thanks I will figure it out.

[Ravindersaini]

Hi, If you arw getting invalid database error than you need to install ace oledb drivers. Regards, Ravinder Singh

[JiriPospisil]

Hi Prateek, I needed to update my OLEDB object to be able to provide it correct connection string, try to import it.