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

  • Thread starter Thread starter George
  • Start date Start date
G

George

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA SQL - variable Source Data... 2
Running a SQL query off an excel table of data 1
Import from Excel to an access database using Jet in vb.net 1
how do I close the connection from excel to access after refresh? 0
VBA Excel data to SQL Sever table 1
Chartspace Data Source and Connection String Problem 0
Get results from Access Database. 1
Source of Data Files? 4

Back
Top