Sorry misread your message. Just skip the part about unloading the structure. Thought you wanted to move the table structure also.
Buddy -----Original Message----- From: Walker, Buddy [mailto:buddy@;medschool.pitt.edu] Sent: Thursday, October 31, 2002 12:51 PM To: [EMAIL PROTECTED] Subject: RE: Moving Tables 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/ ================================================ 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/
