Date used in Table Name. How do I access?

[dhgrrg]

I'm not familiar with this type of database.

The structure is as follows

The master table in Database AAmmddyy.dbf with a companion AAmmddyy.cdx file

Each day’s data is data is stored in a table name with a prefix (AA,AB,AC )and the days date. If I appended all the “mini” tables together I’d have a real table I could work with.

Ex.
AA120904.dbf with AA120904.cdx
AA120804.dbf with AA120804.cdx

Crystal is used internal to the program and the table shown as AAmmddyy.dbf which may be linked to other tables in the conventional manner. (AAmmddyy.dbf to ABmmddyy.dbf.

I’m using Crystal 9. What ODBC connection type do I use, what type database is it, and how do I handle the apparent “variable” table name.

thanks