I have an excel spreadsheet that imports data from Access. I use "Data =>
Import External Data => Import Data". I then point to the Access database
where the queries have been setup, I set the properties of the import and all
is well with the universe. Now, all of a sudden that process doesn't seem to
work at all. Setting up the link between Excel and Access give me no error
messages, yet when I set the query exactly the same way as I have before
today (actually it worked this morning), no data is returned except for the
column headings. It makes no sense to me since when i go to the source file
and open the query I'm trying to link to Excel, the data is there.

Now, after thinking perhaps I just needed to reboot, or to create a brand
new access database, I tried using "Data => Import External Data => New
Database Query". The same basic steps of setting up the link here except it
takes a bit longer to complete the process. But it works fine.

Can anyone explain to me why using Import Data suddenly stopped working?
Frank <sorry for the long-winded message. I'm a bit frustrated>