Data in Microsoft access

Hi All

Can any one please guide ,how can I get the data in Microsoft access on real time same like power query in Excel.


Hi @caneeraj
From discussions on a different forum, and I quote

"Access doesn’t provide any functionality to directly access the data from a HTTP endpoint (REST API). It can only function as a database(backend) in this scenario and you would need to look into other solutions to get the data from the database and provide it from a HTTP endpoint (REST API).

If you’re looking to use Microsoft technologies for this solution, then you can look into ASP.NET Core to provide the Web API functionality.

You’ll need the Access Data Provider to be able to access data in a MS Access database, which as far as I know runs only on a Windows OS."

Please follow the discussions around the same here


1 Like