Pull data from Access query into Excel (2016 versions)

[sk067]

I have a 2016 password protected Access database that contains a query that i need to pull the results from into Excel i have set the database encryption to legacy the issue I am having is that the query uses several functions that are defined in the Access database. when rs.open "select * from qrySalesExport", con runs i get an error stating that one of the named functions in Access is undefined. the query runs perfect inside of Access.

any help is appreciatied!

 

[gheyman]

Did you consider using Excel Power Query to pull in the data?

 

[sk067]

changing process. i have created a public sub to run a make table query then pull the table into excel just need to figure out how to run the sub in a password protected database (dont really want to open a full instance of Access)

any tips or code help on running the sub?