I have a table that I replace from time to time. It is easier and less time consuming to replace than to update. The file I am importing is an Excel file with about 3,000 records. When I first import the file it gives me a table that I can use for other updates. The initial import is about 2,000 records. I will delete the records from the table, import the file to append to the table, and that is when I get subscript out of range. I have another table I do exactly the same with about 2,600 records with no problem; this table has 3 fields to import. The former table has 99 fields. WHy does one work and the other not?