I'll try my best to explain how I need my import to function...
I have table 1 which looks like this in terms of design
AutoNumber AKAName CorrectedName DateAdded
AutoNumber is mainly here to be able to check back to the excel import file that the correct number of records is being used.
Every import must wipe the table, keep the design/form, and then import the new data. I thought I could do a CurrentDB.Execute "DELETE * FROM TABLE" to wipe it clean. Then DoCmd.SavedImportExport. The problem I have is that the only saved import/exports create a new table or append. When you try to save an append it picks up all the extra columns you have to clean out during the import. Append doesn't give you the option you get when you make a new table.
Suggestions?