Is there a diferent "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
 

Hello there, I have been working on a project that is a
program in VBA, that program saves its data on a Database
and then its manipulated by importing that data to Excel.
I was having trouble importing queries from the DB and I
found why. I had to change the DB to prior version so that
the program could comunicate with it, now excel dosent
import queries from the DB because of that, it imports
tables but not queries. I need to know if theres a way to
change the "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" that I am using so that it recognizes the prior
version and import the queries.

Is there a diferent "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
 

If it works with tables then it should work with queries (I am assuming that the query has some records in it). Verify that the name of the query is a valid VBA variable name and if it is not, elclose it within square brackets.