Sorry - I should have said that when I use that simple method, not all the tables and queries in my Access database are listed. So I cannot link to the query I need.
So I realised I could use the MS Query button on the same tab. It was at this stage that I got the 'unrecognizable database format' error. Searching the forums on the web, it seems to be a particular problem that the .accdb is not recognized by Office 2007 or 2010.
So I need your help to either:
a) see the full list of my database queries and tables or
b) be able to set up the ODBC drivers to enable Excel 2007 recognize the .addbc format as a valid data source
OK. So do I have to pay for this? I could have got this from a basic user guide even if I hadn't known it myself.