Take these steps
R:>CONNECT olddatabase
R:>SET NULL -0-
R:>OUT C:\TEMP\tablename.STR
R:>UNLOAD STRUCTURE FOR tablename
R:>OUT TERM
R:>OUT C:\TEMP\tablename.DAT
R:>UNLOAD DATA FOR tablename AS ASCII
R:>OUT TERM
R:>CONNECT newdatabase
R:>SET NULL -0-
R:>RBE C:\TEMP\tablename.STR --REMOVE ALL LINES BEFORE "CREATE TABLE ....."
R:>RUN tablename.STR
R:>LOAD tablename FROM C:\TEMP\tablename.DAT as ascii
If you have any or computed columns then the columnlist should not contain the
computed columns
UNLOAD DATA FOR tablename USI columnlist AS ASCII
Buddy
-----Original Message-----
From: Farnsworth Midge D Contr 388 RANS/JT3
[mailto:Midge.Farnsworth@;HILL.af.mil]
Sent: Thursday, October 31, 2002 12:02 PM
To: [EMAIL PROTECTED]
Subject: Moving Tables
I am running R:Base 6.5++ for Windows and am having a difficult time trying
to combine tables from one database into another database. I went out to
the archive list and can't find a way to do it. I have copied forms and
reports from one database to another, but can't do tables. I finally
resorted to exporting the table from one database into Excel and importing
it back to another database in R:base. When I do this, for some reason, it
changes the date format somehow and doesn't recognize the date. When you
look in the table, the data is there, but when you try
browse * from History Where date BETWEEN 01/01/02 AND 10/30/02
it says there are no qualifying rows. Does anyone know how to do this, and
what the problem might be with the dates?
================================================
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/
