Solved

Microsoft Query

Posted on 2010-08-28
8
574 Views
Last Modified: 2013-11-27
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
Comment
Question by:mato01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 6

Expert Comment

by:radnbne
ID: 33550965
Can you attach a screen shot of the pop-up ?
0
 

Author Comment

by:mato01
ID: 33551054
Here is a print screen of the error I'm receiving
Error.docx
0
 

Author Comment

by:mato01
ID: 33551277
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:mato01
ID: 33551580
Microsoft Excel  2007 Microsoft Query no longer recognizes accdb files,  Do I need to reinstall Microsoft 2007
0
 
LVL 6

Accepted Solution

by:
radnbne earned 250 total points
ID: 33551600
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
 

Author Comment

by:mato01
ID: 33551639
I don't have to use this on my work PC; however, this solutions works perfectly.  Thanks
0
 
LVL 6

Expert Comment

by:radnbne
ID: 33551744
So this fixed your problem?
0
 

Author Closing Comment

by:mato01
ID: 33551749
Problem solved.  Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question