Here's the situation. I have statistics in a Paradox table from which I need
summary information. However, this summary data needs to be updated and
tracked daily. I want to store the summary data into an Access database.
I think that once I get the summarized data out of the Paradox table, I
know how to get it into Access (I think).

So, my first question is:
How do you connect to and query a Paradox table through code? I was able
to connect before using the db.Connect method. However, when I queried with
a SQL statement using DISTINCT, it said it wasn't supported. I only need
to perform aggregate function on the table and store that info in an Access
database.

Any suggestions?

Thanks,
John