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/
