I have designed an Access database with user workgroup security and want to
import data from a certain query or form into Excel.

I go into Data and import data and I select my database. However, when i
click OK nothnig happens and it goes back to the worksheet. If I click test
the connection it says I do not have the releveant permissions despite me
being the administrator!

Many Thanks,
Matt