numeric overflow error

[s4bill]

I am linking excel spreadsheets. I am using a spreadsheet as the source to update a database table. I am running an append query.

I have checked all the fields and it seems that they are correct.

It will run one time and then the second time it will produce this error.

If I change something in design view and run it prior to saving it - it will run.

As soon as I close the query and reopen it to run it - it errors.

I read somewhere about optimization and that it may be causing it.
There may be VBA or macro code to assist with this?

Does anyone have any ideas?

Thanks
Bill

 

[namliam]

It is probably something to do with a number field, that in the first instance is an Integer and in the second a double (or something like that)

 

[s4bill]

number field

I do believe it is a number field causing the problem.

But I do have the field properties correct.

I read somewhere about a macro that will assist with this.

 

[namliam]

No macro that I know of. Its atleast odd that it will run when eddited and not when saved...