Hi Buddy,
I tried the following using your example and still get the error "Invalid
Variant" (see attached)
GATEWAY IMPORT XLS 'Dealers and Discount List.XLS' create TmpAddr OPTION
SHEET_INDEX 0|FIRST_ROW 2
----- Original Message -----
From: "Walker, Buddy" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, June 14, 2008 6:43 AM
Subject: [RBASE-L] - RE: Gateway error importing .xls file
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
