Karen, sorry I missed you want to differentiate between zero and null. In that case, type in the x for no information as referenced earlier and replace the x with null. You can use several different approaches in Excel to accomplish the same results.
When complete on development, create a macro for their system. Gary From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Saturday, August 27, 2011 11:11 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Importing Excel spreadsheet Karen, here is another possible solution. In Excel, there is a search and replace function. Try the following steps. 1. Type the data in all cells. Where there is no data, enter a zero. 2. Use the Find and Replace function of Excel to find and replace all zero's with the null value '-0-' a. As the Replace function will replace all zero's in the spreadsheet with null, use the option to Replace on the data in only the column. b. If this is good enough, then you can set up a macro in Excel to do the above based on a simple key stroke. 3. Save the data and load into RBase. 4. Once you load the data, null values should be in place. I have tried a small sample on the above and found it to work. Gary From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, August 27, 2011 8:40 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Importing Excel spreadsheet 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
