View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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