So I'm trying to set up a link in Excel 2007 to a query in a Access 2007 database but the result I get are the headers and 2 blank rows. When I check the query in Access, it comes through fine. Whats wrong? How do I fix the link?

Hi

I think a little more info is required, ie. what are you trying to achieve and what are you doing now that dosn't work?

MTB

I have a query that I've created in Access. Results are perfect. When I go to Excel and try to create a link to that query, none of the results show in Excel. I only get the header row and 2 blank rows. I can export the query to an Excel sheet, but I want the convenience of the refresh option.

Yes that's fine, but how are you attempting to make the link?

For instance, are you using VBA: if so could you post the code?
In addition you could also post the SQL string of the query that woork in Access.

MTB

No, i'm just using the wizard. Data ribbon, Get External Data, From Access, browsing for my database and selecting the query I want to link.

The only thing that I can think of is that the query is pretty complex (many joins, many iif statements) that it times out after a certain amount of time. does this sound logical?