Missing Access Select queries from import wizard

[L33]

Hi,

I'm very new to PowerPivot so I suspect the answer here will be a very simple one. Basically, I have 21 fairly basic Select queries in an Access database, and want to import the results of some of them in to a PowerPivot model. In the import wizard view where I can pick which ones, there are 4 queries missing. I can seeing nothing about these 4 queries that's particularly different to the others...

Can anyone give me any pointers as to what it might be about those 4 that's preventing them from turning up? I'm using Access 2010 and Excel 2010.

 

[RoryA]

Do they use any Access functions like Nz?

 

[L33]

No, there's nothing in them that seems even as complicated as that -simple select queries that build on each other. However - I didn't write the Access DB elements, and the member of my team has since done something to them that seems to have resolved the issue. He seems to think it's to do with how long they take to run...?