| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Not able to generate query from excel for access 2007
Hi All,
I am trying to import data from access database to excel using Microsoft query option in excel, but it doesnt allow getting data from access 2007 version which has .accdb extension. I am able to select the 2007 database by selecting "All files" options but then it gives me an error "unrecognized data format". Can we not generate the query using Microsoft query option in excell for access 2007? Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP: Not able to generate query from excel for access 2007
Can you post you connection statement and the openrecordset statement with the SQL stinrgs. The version number in one of the statmeents need to be changed. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=167799 Microsoft Office Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using MS Query with Excel and Access 2007 | 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) | |||
Hybrid Mode
