Hi all,
I'm hoping someone can stop me tearing (what's left of) my hair out
over this problem...
I have a linked Excel file from which I append the data to an empty
local Access table.
I have a macro which runs a delete query to empty the local table, then
the append query to update it with the new info from the spreadsheet.
I'm getting the error "Numeric Field Overflow" when running the
append query, it doesn't happen every time though.
I've found that I can make the append query run by going in to the
design view and making a change to something (anything), for example:
Re-selecting the "Append to" part of one of the fields (i.e. The
Supplier field updates to "Supplier" in the table and I'll
re-select "Supplier" from the drop down list, they query will then
run as it should)
Only one of the fields in the table is a number field and it is set to
Long Integer.
There are two currency fields and two date fields, everything else is
text.
I don't understand how the macro will run sometimes and, using the
exact same data, not run the next time?
Can a Numeric Field Overflow apply to a currency field or date?
My access knowledge is limited.
Access 2000, Win XP
Steve