Midge Do the two databases BOTH have the same table? Are you ADDING rows in the SAME table in one db to another or replacing them or is it a new table?
In either event, the command you want is UNLOAD: OUTPUT filename UNLOAD (ALL/SCHEMA/DATA) FOR TABLEname OUTPUT SCREEN The result is a file which can be moved into the directory where the other database is and then used with RUN filename. The "SCHEMA" option will create a file that, when run, builds the table structure, with no data. The "DATA" option will create a file that assumes that the other database has the same table with the same structure and when RUN it will load that table with those rows. The "ALL" option creates the newr table and loads the data in. David BLocker ----- Original Message ----- From: "Farnsworth Midge D Contr 388 RANS/JT3" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 12:02 PM 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/
