Excel and External Data from Access

[Martynt74]

Hi Have a range of spreadsheets which contain data for various offices.

I have an Access database which has a created table containing information on all offices.

On my old version of Excel i was able to import external data and then filter so it only imported data for specified offices.

This was great as it meant i had one table with multiple spreadsheets linking to it and filtering the information they each needed.

However in Excel 2010 when i import the data i don't seem to be able to filter on the data so it ends up just importing the whole Access Table into each spreadsheet.

I know i could then filter in Excel and delete the unneeded lines, however i re-run this Monthly so it'd be a bit of a pain to do for 30 offices each time.

Hopefully that makes sense and could anyone help me do what i used to?

Thanks
Martyn

 

[Martynt74]

Ignore this folks i've managed it!

 

[Participant]

Oh how I love it when people post that they've found the solution to their problem, but don't say what that solution was. That way, if anyone with a similar problem stumbles across this thread, they still end up with no idea how to solve their problem...yay!

 

[Martynt74]

Whoops. Sorry.

For some reason if you select to import data from Access directly it just imports the table.

However if you choose to import data from a Microsoft Query, and then choose Microsoft Access as a data source it lets you be more specific