Getting external data from Access 2007 using msquery
 

Hwne i try to do this i have two problems, 1. it does not recognize the
Access database (.accdb) and the if i do select it it wants a username and
password and the database has niether, i built it.

The need to be able to pull data into excel2207 from this database. is
there no way to this other then exporting the data from Access (not
acceptable). with the loss of analyze with functionality i am at a loss how
to do this. MSquery seems to be the unwanted step child, with little or no
support.