Eric, Thanks for the confirmation and the suggested work around. I thought the women's figure skating competition last night distracted me or I was dreaming early. I'll report to RDCC.
Stan Loo ----- Original Message ----- From: "Eric M. Bienstock, Ph.D." <[EMAIL PROTECTED]> To: "RBASE LIST" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 10:04 AM Subject: Re: dBase 4 File > Stan, > I tried some experiments and confirm your results (truncation to 28 > characters when you ATTACH a db4 file in R:BASE). You ought to report it to > RDCC. I also found the following work-around: In Excel, for each column > containing a cell wider than 28 characters, make the column heading as wide > as the widest cell. Be sure to maximize all column widths. Then do the > "save as db4" procedure and ATTACH in R:BASE. You will find that the column > headings will get truncated to 10 characters, but your data will be intact. > > -------------------------------------------------------------------------- - > Eric M. Bienstock, Ph.D. > Database Development, etc. > Authorized R:BASE Developer > Eric M. Bienstock & Associates, Inc. > day: 212-978-7948 eve: 973-763-8650(8) > FAX: 775-254-2109 [EMAIL PROTECTED] > http://members.home.net/ericmb/Ericmb.htm > -------------------------------------------------------------------------- - > > ----- Original Message ----- > From: "suredata" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 8:59 AM > Subject: Re: dBase 4 File > > > | Eric, > | > | I did. I also removed all cell borders, and bold and italicized fonts, > | etc., leaving a plain Jane version. Saving the data as dBase 3 file gave > me > | the same result -- truncation of text longing than 28 characters. Has > | anybody experienced the same thing? > | > | Stan Loo > | > | > | ----- Original Message ----- > | From: "Eric M. Bienstock, Ph.D." <[EMAIL PROTECTED]> > | To: <[EMAIL PROTECTED]> > | Sent: Friday, February 22, 2002 1:12 AM > | Subject: Re: dBase 4 File > | > | > | > >All text longer than 28 got truncated. > | > > | > Stan, > | > Before selecting and saving the records in Excel, be sure to maximize > the > | > width of each column. > | > > | > > -------------------------------------------------------------------------- > | - > | > Eric M. Bienstock, Ph.D. > | > Database Development, etc. > | > Authorized R:BASE Developer > | > Eric M. Bienstock & Associates, Inc. > | > day: 212-978-7948 eve: 973-763-8650(8) > | > FAX: 775-254-2109 [EMAIL PROTECTED] > | > http://members.home.net/ericmb/Ericmb.htm > | > > -------------------------------------------------------------------------- > | - > | > > | > ----- Original Message ----- > | > From: suredata > | > To: [EMAIL PROTECTED] > | > Sent: Thursday, February 21, 2002 9:56 PM > | > Subject: dBase 4 File > | > > | > I saved some Excel data as a dBase 4 file. Both column names and data > | were > | > selected before saving in dBase 4 format. After successfully attaching > | the > | > file in RBase for Windows 6.5++, I discovered that the maximum text > column > | > length was only 28. All text longer than 28 got truncated. Is this a > | dBase > | > 4 limit, or something else? > | > > | > Thanks. > | > > | > Stan Loo > | > > | > ================================================ > | > TO SEE MESSAGE POSTING GUIDELINES: > | > Send a plain text email to [EMAIL PROTECTED] > | > In the message body, put just two words: INTRO rbase-l > | > ================================================ > | > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > | > In the message body, put just two words: UNSUBSCRIBE rbase-l > | > ================================================ > | > TO SEARCH ARCHIVES: > | > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > | > > | > | ================================================ > | TO SEE MESSAGE POSTING GUIDELINES: > | Send a plain text email to [EMAIL PROTECTED] > | In the message body, put just two words: INTRO rbase-l > | ================================================ > | TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > | In the message body, put just two words: UNSUBSCRIBE rbase-l > | ================================================ > | TO SEARCH ARCHIVES: > | http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
