var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Numeric Overflow when select *
I get a "Numeric Overflow" when i run a SELECT * FROM TABLE,
I've had this problem with several queries and I'm getting very annoyed by it.
If i open the question i design view and removes everything and then adds it again it works a few times or only one time.
Is there some kind of setting i Access that makes this happening or what?
it depends on how your nummeric value is defined
these are the values you can use
name : how much memmory : value to value
Integer : 2 bytes : -32,768 to 32,767
Long(long integer) : 4 bytes : -2,147,483,648 to 2,147,483,647
Single(single-precision floating-point) : 4 bytes : -3.402823E38 to
-1.401298E-45 for negative values;
1.401298E-45 to 3.402823E38 for positive values
Double (double-precision floating-point) : 8 bytes :
-1.79769313486232E308 to -4.94065645841247E-324
for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values
It must have SOMETHING to do with numeric values but I don't see how.
I've got a link to an Excel sheet and I want to select all from it into a new table and order it by one column. The query is a "make-table" query so it deletes the old table each time it is run.
There are some columns that are text and some that are numbers.
The strange thing is that if I redesign the question in the exact way that it was written before it works at least one time before crashing.
Did you ever get a solution to the overflow problem with queries - I'm having the exact same problem making a new table from an excel spreadsheet.
Originally posted by oneleg_theone
Re: Numeric Overflow
It sounds like access is setting the type for the field based on the data from excel and in turn an overflow is happening. This does not explain why it works sometime, instead of doing a make table query try chagning to an append query, and change all of the field types in the access table to text. If this gets around thew problem then it has something to do with the above.