Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query with Excel and Access 2007
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query with Excel and Access 2007
Thanks! The SMALL() function is exactly what I was looking for.
Ari "mipoit" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query with Excel and Access 2007
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. "mipoit" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query with Excel and Access 2007
Ignore my last answer. Go to Data - from Access - then you should see the
..accdb files - I think. "mipoit" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
edit query in Escel 2007 pulled from Access? | Excel Discussion (Misc queries) | |||
Excel 2007 - Query MS Access DB | Excel Discussion (Misc queries) | |||
Excel 2007 Query Wizard problem with Access 2007 extensions | Excel Discussion (Misc queries) | |||
Import Access query to Excel 2007 | Excel Discussion (Misc queries) | |||
access-type query in excel 2007 | Excel Discussion (Misc queries) |