External data not updating
 

Hi,

I have an Excel 2003 worksheet which I have imported external data.
This comes from Access 2003 via Microsoft.Jet.OLEDB.4.0(Data - Import
External Data - Import Data). When I open the query in Access, it
returns 30 odd rows. However, when I import that query into Excel,
nothing appears apart from the column headings.

If I import data using Microsoft query (Data - Import External Data -
New Database Query), it returns the expected results.

Hopefully someone can help?

Thanks,
Matt