Numeric Field Overflow

[mtairhead]

Good ol' Error 3349.

I have a make table query, which filters data from a linked table and creates a new table of results. The linked table is (Of course...) linked to an Excel spreadsheet. Whenever I run the query, I get the error message "Numeric Field Overflow."

I've done some research on this forum (Found plenty of people with a similar problem, but no solutions that work for me) and I have officially deemed it "not a coincidence" that this error seems to pop up whenever someone is using Excel within Access. (Linking excel files, etc) ...Only, why would one table work and the exact same (Just a different name) not?

Thanks,

Andrew

 

[KenHigg]

In my experience, numeric overflow errors most often happen when a value is too large to fit into a numeric type data fld. Which I usually fix by changing numeric flds to a 'double' data type.

From another angle, if you're linked to a xls file, and the number of rows exceeds something like 32k, you may be hitting an Excel row limitation...

Ken