topic Hi Prateek , In Database give in Product Forum

Trying to read excel file OLEDB object

PrateekMehan — Thu, 13 Jul 2017 16:18:00 GMT

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.

Hey,

Anonymous — Thu, 13 Jul 2017 18:20:00 GMT

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.

hi,

PrateekMehan — Thu, 13 Jul 2017 21:29:00 GMT

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

Hi Prateek , In Database give

leela — Fri, 14 Jul 2017 06:50:00 GMT

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

Hi,

Anonymous — Fri, 14 Jul 2017 10:29:00 GMT

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

I am trying to read an excel

PrateekMehan — Fri, 14 Jul 2017 11:24:00 GMT

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.

Hi,

Ravindersaini — Fri, 01 Sep 2017 23:40:00 GMT

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

Hi Prateek,

JiriPospisil — Tue, 05 Sep 2017 15:05:00 GMT

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