Crystal Report – VB (Table Change)

Situation.: Data of each day is stored on seprate tables, with the same field names.
The table are saved as myData_01Jan04, myData_02Jan04, myData_03Jan04…
Query:
1,I have designed a report for a perticular table. Now I want to change the name of the table throught VB. So that I can use the same report to view the data in the archive files.
2,Does the solution change it I use Access instead of SQL Server.