Unkown error

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

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?
 
Which action in the macro produces this error? If it's opening or
running a query, what is the SQL of the query?
 
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!

John said:
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:
Click to expand...
[quoted text clipped - 5 lines]
Does anyone know why I would get that error randomly?
Click to expand...
Click to expand...
 
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!

John said:
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:
Click to expand...
[quoted text clipped - 5 lines]
Does anyone know why I would get that error randomly?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top