Unkown error

[ladybug via AccessMonster.com]

I have a macro that has a series of Append and Unmatched queries. Evey day I
import data and it loads. Every once in awhile I get an error that says this:


Field 'F18' doesn't exist in destination table 'TempProduction'

I have not touched that table in months and I double checked and that field
does exist on the spreadsheet I am loading and in the tempproduction table.

Does anyone know why I would get that error randomly?

 

[John Nurick]

Which action in the macro produces this error? If it's opening or
running a query, what is the SQL of the query?

 

[ladybug via AccessMonster.com]

I am not sure. I do not think any queries are ran before the error. I just
tried loading it this morning and it worked fine. I do not understand why
this happens randomly. I guess I will have to wait until the next time and
see when it happens. Thanks for trying!

Which action in the macro produces this error? If it's opening or
running a query, what is the SQL of the query?

I have a macro that has a series of Append and Unmatched queries. Evey day I
import data and it loads. Every once in awhile I get an error that says this:

[quoted text clipped - 5 lines]

Does anyone know why I would get that error randomly?

 

[John Nurick]

It won't be happening randomly. Most likely, it's caused by something
in the spreadsheet. Next time it happens, compare the spreadsheet
you're importing then with one that imported OK, especially in or
around the column that corresponds to field F18.

I am not sure. I do not think any queries are ran before the error. I just
tried loading it this morning and it worked fine. I do not understand why
this happens randomly. I guess I will have to wait until the next time and
see when it happens. Thanks for trying!

Which action in the macro produces this error? If it's opening or
running a query, what is the SQL of the query?

I have a macro that has a series of Append and Unmatched queries. Evey day I
import data and it loads. Every once in awhile I get an error that says this:

[quoted text clipped - 5 lines]

Does anyone know why I would get that error randomly?