Using MS Query with Excel and Access 2007

M

mipoit

Hi, I have both Excel and Access 2007 on my machine. I am trying to use the
Microsoft query tool to bring access 2007 data into my spreadsheet.

From the data tab I click "From Other Sources" then "Microsoft Query".
From the Choose Data Source Dialog I select "Microsoft Access Database" and
navigate to the directory that contains my Access 2007 database.

My problem is that I cannot see the database with the new 07 extension
(accdb). I can only see the old mdb files. Other than converting all of my
accdb files to mdb version. Surely there must be something that I am
mising... help please.
 
D

dhstein

This is just a guess - but be sure you have the correct references. Go to
Visual Basic Window (Alt - F11) then go to tools - references and add
Microsoft Office 12.0 Office Library.
 
D

dhstein

Ignore my last answer. Go to Data - from Access - then you should see the
..accdb files - I think.
 

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

Copy and move Access 13 database on laptop to pc with Access 13 0
2007 Pivot Tbl to Access Conversion Issues 6
Access 2007 1
Excel 2003 to Access 2007 1
mdb format and Access 2007 3
Access MS Access 2013 to MS Access 2010 Conversion Issues 0
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Getting query data from Access 1

Top