Incomplete Queries 1

[cybermud]

I have a paradox 9 database that is updated every half hour by an external system....I am trying to query that in Excel using MSQuery manually, on a daily basis, to make a chart. My problem is that the queries are incomplete. For example, I have data up to today, that I can see if I view
the database on the Paradox machine, but if I run a SIMPLE query (select * from table), not all of the data is returned...only data up to a few days ago. Does anyone know why this is happening? It is quite perplexing...

Thanks,
Erik