Then the next week I want to delete the original tables and import the new data from the website creating "fresh" tables from scratch
I have had issues with this sort of thing in the past, as it is tough to get the fields and indexes set-up exactly the way you want each time.
I have had much greater success simply deleting all the data from the existing table with a line of SQL code like this:
Code:
DELETE [Table1].* FROM [Table1]
and then using an Append Query to add all the new records to the table.
That way the structure of your table never changes and you do not need to worry about how it is being set-up (and you only have one Table to worry about).