HELP: Not able to generate query from excel for access 2007

[sam]

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

 

[joel]

Can you post you connection statement and the openrecordset statemen
with the SQL stinrgs.


The version number in one of the statmeents need to be changed