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

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