Import External Data from Excel

[ebrooks54]

I apologise, if this isn't quite the right place to post this question, but it is related to an Access Query.

I have a query in an Access DataBase called "Test", and I want to load it in an Excel spreadsheet. In Excel, there appear to be 2 ways to do this:

1) Data/ Import External/Import Data or
2) Data/ Import Data/ New Database Query

Either way allows you to get to the query, funny thing is that they return different results.

Option 1 seems to ignore any criteria that exists in the query and returns all the records, whereas Option 2 recognizes the criteria and only returns the relevant records.

Can anyone explain why this is the case, and is there any literature on what the proper way to access external data is?

Thanks

 

[Zonie32]

I usually just run my query in Access, then click Tools, Office Links, Analyze with Excel. This puts the data right into Excel. I use Access 2003 on Win XP.

 

[ebrooks54]

I forgot to mention, I am using Office XP. The application of my process is to provide Excel data to another user. The person retrieving data knows nothing about Access, so the preference from the user perspective is to not have to go in to Access. Also, the data is being retrieved into the 5th row of an Excel spreadsheet that has different headings than the Access Field names.

Thanks