But remember, they're typing data into the spreadsheet, so typing a big negative number like that would be a pain. Since negative numbers would not be allowed in this field, I did tell them that they could type in -1 and my program could change it to null. But typing in an "x" did the same thing and was easier for them. Still... thinking that gateway should recognize a blank field and import it as such, unless Excel internally is storing it as a 0 (kinda like the weird way it internally stores dates) and there's nothing RBase can do to undo that.
Karen In a message dated 8/26/2011 6:55:50 PM Central Daylight Time, [email protected] writes: > You could try doing something like replacing all the nulls with some > crazy negative number > that you could change after import. You know like -1965432765 > >
