Bernie Not sure about the error message you are receiving but when importing from excel the sheet numbering starts with 0 also make sure you indicate what row the data starts in.
GATEWAY IMPORT XLS C:\TEMP\BOOK2.XLS APPEND + TmpExamGrades OPTION SHEET_INDEX 0|FIRST_ROW 2 Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Friday, June 13, 2008 9:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway error importing .xls file Hi Experts, I have an Excel spreadsheet and when trying to import it I get the following error: Invalid variant type. There are 3 sheets but sheets 2 and 3 are empty, I only want to import from sheet 1 What should I look for? Bernie Lis
