VBA to Import data into Access 03

So are the tables you download and import new each time like Sales?

A bit about Indexing: Click here

If this is going to be a continually growing database as data is added once a week. It would be beneficial to take the little extra time to setup indexing.

For me personally if I had something like this:
I would use a Linked File and run my downloads(ie update the linked file)
Write VBA to copy the Linked File into a Table(with Indexes already setup) with an extra field for the date I imported it.
Create my reports based on that table. Have a button that I would use annually to clean up that file. Ie. Create a history table for each year - this would allow me to re-create any report I had ever made in a few clicks.

Hope this helps,

Dan