Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 609
  • Last Modified:

Microsoft Query

I'm trying to use Microsoft Query in Excel to connect to a Access Database I get the below pop up box.

Login

Data Source
MS Access Database

Authorization
Login Name
Password

Please advise


0
mato01
Asked:
mato01
  • 5
  • 3
1 Solution
 
radnbneCommented:
Can you attach a screen shot of the pop-up ?
0
 
mato01Author Commented:
Here is a print screen of the error I'm receiving
Error.docx
0
 
mato01Author Commented:
I found out that I need the OBCD driver for accdb.  Looked on microsoft can't find it.  Do you know where I can locate the driver for accdb.  Only have it for mdb.


MS Access Database....Microsoft Access Driver (*.mdb, *.accdb)
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
mato01Author Commented:
Microsoft Excel  2007 Microsoft Query no longer recognizes accdb files,  Do I need to reinstall Microsoft 2007
0
 
radnbneCommented:
I have tested a connection using MS Query ok here.  what steps are you taking to connect the database?

The steps I used were as follows:

From the Data Menu
Select From Other Sources
Select From Microsoft Query
Select MS Access Database (if this doesn't exist you need to add it back in...settings  attached)
Click OK
Select the database file to use...then follow the prompts to add the data to your worksheet.



setting1.jpg
0
 
mato01Author Commented:
I don't have to use this on my work PC; however, this solutions works perfectly.  Thanks
0
 
radnbneCommented:
So this fixed your problem?
0
 
mato01Author Commented:
Problem solved.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now