Transferspreadhseet

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi,

I am using the transferspreadsheet method, when I try to
upload a spreadsheet I keep getting VB error '3349' -
"Numeric Field Overflow". This issue is perplexing
because when I attempt to upload the spreadsheet on my
machine, I DO NOT get this error. When I try and upload
the exact same spreadsheet on somebody else's machine, the
error ALWAYS appears (the file is emailed to the other
user).

Any ideas as to what could be causing the error on my
users machine?

P.S. - The user has been able to upload some spreadsheets,
but there are a couple of spreadsheet that always cause
this error.

Thanks!

Tim
 
Generally speaking, that message usually means that there is some sort of
mathematical error (dividing by zero for example).
 
Guessing that there is a filed with numeric data in it, anf the values of
the first rows is within the limit of an integer, and then later rows have
values in the range of long integer (or single/double decimal). The number
of rows that ACCESS looks it in EXCEL in order to determine the field type
is found in a registry key setting, and this value can be different on
different PCs. Thus, if your PC has a larger value in the registry than the
other PC, and the long integer value is within the number of rows for your
PC's value, while the other PC has a smaller value that stops before a long
integer (or single/double decimal) value, it'll fail on the other PC.

Try putting the long integer (or other value from a row) in the first row of
the EXCEL sheet and see if the problem goes away.
 
Ken Snell said:
Guessing that there is a filed with numeric data in it, anf the values of
the first rows is within the limit of an integer, and then later rows have
values in the range of long integer (or single/double decimal).
Click to expand...

I don't think that is correct. My experience is that Jet always
interprets a numeric Excel column as type 'Double'.

Jamie.

--
 
Back
Top