I am trying to access data from an Access Database within Excel. I'm using the the Get External Data > From Access button to link through to my access database. When I do this, I see some of the queries within the database but not all of them. Please could someone explain why the are not all visible and how I make the one's i need visible.
My Access DB is in accdb file format
I'm using Excel 2007 too.
I'm not that familiar with VBA and am looking for a solution that doesn't involve coding.