Error in OLEDB Query

Anilkumar_Vunduru — Wed, 16 Dec 2020 10:40:17 GMT

Hello all,

I'm using a query to get the required data from Access db.
Query: SELECT * FROM [OCT2020] where OCT2020.column name IN (data)

However, it's throwing an error and adding an extension (.txt) as below.

Error: Internal: Could not execute code stage because exception thrown by code stage: The Microsoft Access database engine could not find the object 'OCT2020.txt'. Make sure the object exists and that you spell its name and the path name correctly. If 'OCT2020.txt' is not a local object, check your network connection or contact the server administrator.
Please help on this.

Thanks,
Anil

Re: Error in OLEDB Query

hossein.azimi — Wed, 16 Dec 2020 11:14:46 GMT

Hi Anil,

Make sure you have installed the Microsoft Access Database Engine 2007or 2010 or 2013 or 2016 Redistributable.
It depends on what version MS Access you are using you need to install the access database engine.

topic Re: Error in OLEDB Query in Product Forum

Error in OLEDB Query

Re: Error in OLEDB Query