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.