| What I've done in the past was to highlight the area I want save
| including the column names (make sure the names don't conflict with your
| database) next save as DB4 file. At the R:> attach to the DB4 file and
| unload the data as ascii to a file. Detach the DB4 file. Now load your
table
| from the file as ascii.
==========================================
I agree with Buddy in recommending this technique. Additional comments:
- Very important to highlight the rows and columns containing data,
including the column names.
- After you choose "save as db4" you still must close the worksheet. Do not
save changes.
- You can modify any of the column names when you do the ATTACH (if R:BASE
complains that they already exist)
- Once the ATTACH is done, you can insert into a regular R:BASE table. No
ASCII file needed.
---------------------------------------------------------------------------
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: 209-882-9250 [EMAIL PROTECTED]
http://members.home.net/ericmb/Ericmb.htm
---------------------------------------------------------------------------
----- Original Message -----
From: "Walker, Buddy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 7:00 AM
Subject: RE: Issue with GATEWAY in RBW 6.5++ - Razzak's Reply
| J.M.
|
| What I've done in the past was to highlight the area I want save
| including the column names (make sure the names don't conflict with your
| database) next save as DB4 file. At the R:> attach to the DB4 file and
| unload the data as ascii to a file. Detach the DB4 file. Now load your
table
| from the file as ascii.
|
| Buddy
|
| -----Original Message-----
| From: J.M. GRATIAS [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, February 06, 2002 6:06 PM
| To: INTERNET:[EMAIL PROTECTED]
| Subject: Re: Issue with GATEWAY in RBW 6.5++ - Razzak's Reply
|
|
|
| Razzak :
|
|
| >>
| 1. Highlight all columns and rows (without header information)
| 2. Save As CSV file
|
| Then,
| Using The Glorious R:BASE 2000 (ver 6.5++) for Windows:
| LOAD Tablename FROM CSVFileName.CSV AS CSV<
| <<
|
|
| Excell 97 offers 2 CVS formats in the 'Files/Save under FileName' menu :
|
| - CVS (delimiter = semi colon),
| - CVS (OS2 or DOS)
|
| Both outputs fields separated by a semi colon and without quotes arround
| each field ....
| I can't use those formats because some of my fields may contents already
| some semi colons.
|
|
| J.M. GRATIAS, Logimatique
| ================================================
| 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/
