Thanks Buddy, The SHEET INDEX is what I was missing and that did the trick; thank you very much. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax <mailto:[email protected]> [email protected] _____
From: [email protected] [mailto:[email protected]] On Behalf Of Walker, Buddy Sent: Friday, January 28, 2011 4:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway Export Question Javier DELETE C:\TEMP\MyWorkSheet.XLS GATEWAY EXPORT XLSW C:\TEMP\MyWorkSheet.XLS + SELECT blah blah... OPTION BLANK_IF_ZERO ON + |SHEET_INDEX 0 + |TAB_NAME something + |COL_NAMES ON ... GATEWAY EXPORT XLSW C:\TEMP\MyWorkSheet.XLS + SELECT Blah Blah .. OPTION BLANK_IF_ZERO ON + |SHEET_INDEX 1 + |TAB_NAME somethingElse + |COL_NAMES ON ... Notice the Sheet_INDEX option this is your key always start with 0 and continue from there. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Friday, January 28, 2011 4:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway Export Question Hello, I have the need to create a spreadsheet with several tabs, each with data from a separate table. What is the procedure to do this? I have tried several options but each re-creates a news spreadsheet rather than creating a new tab on the same spreadsheet. Any help will be greatly appreciated. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax <mailto:[email protected]> [email protected]
