Source language: Translate to:

Numeric Overflow with Spreadsheets

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Numeric Overflow with Spreadsheets

Postby datadon » Wed Oct 26, 2011 9:43 am

When trying to update the data in an exce spreadsheet, I get the Numeric Overflow error message. It dosen't seem to matter what the field is, general, numeric or text, it show up with all of them. I have tried using the string replace and using setvar to revise a field value. some times it lets me make one change and then give the error message after that. I have also tried the ! symbol in front of variables, still get the message.



Seems I remember hearing something about this being unique to spreadsheets.

Anyone have any ideas or comments on this?
Don

'If you want to get a brontosaurus from 'a' to 'b' then you ride the dinosaur - you don't carry it!'
User avatar
datadon
 
Posts: 389
Joined: Sun Apr 03, 2005 7:55 pm
Location: Lorena Texas

Postby Neosoft Support » Wed Oct 26, 2011 10:18 am

I can't reproduce that error here. It may have something to do with the version of Excel used to create the file. If you can provide an example pub and Excel worksheet that demonstrates the problem, I would be happy to take a look at it.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest