Unable to open Access database from Excel

Hi All,

I am in the process of automating a task in which I need to open an access database from excel and copy paste a list of entries from a specific column to a table, run the query and export the result in excel format.

Here is the process in detail.

Enclosed is the initial report we get from a source. The first step is to copy the entries in column M to the access database to the table called "Input entry" and run the query name "X to Y" and export the result in excel format to a desired location.

Here is my suggested automation. When we get the initial report, copy all the details in a template, a single click which open the access database automatically and copy paste the required field to the table and run the query automatically and save the result in excel format in a desired location automatically. Can anybody help me out doing this task. Process has not completed yet and a lot more is there. Once the initial step is success, I will let you all know the further process.

Best Regards,

Saravanan