Error in OLEDB Query

[Anilkumar_Vunduru]

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

[hossein.azimi]

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.