Error 3349

[Ian SWS]

Using an append query to populate a linked Excel spreadsheet gives "Numeric field overflow (Error 3349)" after 1453 rows have been added to the spreadsheet. This happens when I run the query manually, via RunQuery or Execute. There are no numeric fields being added to the spreadsheet when this happens.

 

[Ian SWS]

Using an append query to populate a linked Excel spreadsheet gives "Numeric field overflow (Error 3349)" after 1453 rows have been added to the spreadsheet. This happens when I run the query manually, via RunQuery or Execute. There are no numeric fields being added to the spreadsheet when this happens.

 

[bd1]

I may have found the problem, at least in my case. I discovered that
date field in the linked SS had some invalid information in i
(non-valid dates). Once I corrected them, the query ran w/o an
errors.

"Numeric field overflow (Error 3349)" after 1453 rows have been adde
to the spreadsheet. This happens when I run the query manually, vi
RunQuery or Execute. There are no numeric fiel
ds being added to the spreadsheet when this happens.

-
bd