Create the temp table first and then append/replace the data.
Or add 'temporary' between the create and aaa. Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of Heffelfinger, Duane Sent: Wednesday, February 17, 2010 9:17 AM To: RBASE-L Mailing List Subject: [RBASE-L] - GATEWAY Question Rbase 7.6 Good morning, Is there a way to very quickly create a temporary table from an Excel spreadsheet at the R>? The syntax below from the help file appears to create a table. Is it possible to make it temporary? GATEWAY IMPORT XLS D:\TEMP\FNAME.XLS CREATE AAA OPTION SHEET_INDEX 0|COLUMN_COUNT 5 Thanks for any input. Duey
