Probably a dumb question, but wouldn't it be easier to combine ASCII or CSV files both for output and input??? ~Claudine :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] On Behalf Of Farnsworth Midge D Contr 388 RANS/JT3 Sent: Monday, October 21, 2002 3:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Selmargin I have up to 11 different users on the database at one time. One of them needs to run 6 different reports and combine them into an Excel file with 6 different spreadsheets. They then e-mail this file to numerous users who don't have access to R:base. If they use GATEWAY to export the reports, then only one user can be logged on at a time. Since all the users are not in the same building, they have to call everyone and make sure that everyone is out before they can run the GATEWAY command. This is a BIG hassle to put up with every morning. We already do it once a week for importing data. -----Original Message----- From: Javier Valencia [mailto:javier.valencia@;vtgonline.com] Sent: Monday, 21 October, 2002 14:08 To: [EMAIL PROTECTED] Subject: RE: Selmargin Why are you trying to send a report to Excel? Would a word processor be more adequate? If you just want to use the data, then you probably need to use GATEWAY and export you data in excel format. Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of Farnsworth Midge D Contr 388 RANS/JT3 Sent: Monday, October 21, 2002 2:24 PM To: [EMAIL PROTECTED] Subject: Selmargin I am trying to print a report to an Excel file. I have tried to reset the left margin to 1 without any luck. I tried SET SELMARGIN 1 and it didn't do anything. OUTPUT NORTHFIN.XLS SET SELMARGIN 1 PRINT EMNOR WHERE fldate >= .sdate AND fldate <= .edate + ORDER BY fldate, zstart, zstop, flline OUTPUT NORTHFIN.SCH SET SELMARGIN 1 PRINT EMNOR WHERE fldate >= .sdate AND fldate <= .edate + ORDER BY fldate, zstart, zstop, flline What am I doing wrong? ================================================ 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/ ================================================ 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/
