Sometimes get subscript out of range

[khughes46]

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?

[pbaldy]

First thing I'd look for are values that exceed the limits specified in the destination table.

[ranman256]

If I see the code line that fails , I could guess better.
But if you are running a delete query to empty the table, you will never get this error.

[khughes46]

THe values are always the same. The import is to get new records. I have no way of know what is new until I compare the data to what is already in the DB. The files contains names and addresses and associated codes to identify certain and specific needs and requirements. The code fields are 2 to 10 characters.

[pbaldy]

Can you post the db and spreadsheet here for testing?

[khughes46]

In trying get a redacted DB for testing, the error won't repeat; it's working fine. When it happens again I'll be sure to send the DB at that time. Thanks.

[pbaldy]

It's like when your car never makes the sound when you bring it to a mechanic. As soon as you leave it starts up again.

[khughes46]

Happens to you too!

[pbaldy]

I've been on both ends of it. Can't tell you how many times somebody has asked me to come look at something acting up on their computer and everything works perfectly when I'm watching.