----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, June 14, 2008 10:32 AM Subject: [RBASE-L] - Re: Gateway error importing .xls file
> Hi Mike, > I get the same error whether I use workbook or spreadsheet. > When I try to export from excel as csv, it creates another excel It doesn't mean anything special because the "File Association" for *.csv is set to Excel as Excel can read *.csv files natively. An exported CSV file is still just that, a CSV file. If you would turn off "hide file extensions of known FileTypes" in your Windows Folder settings: Windows Explorer>Tools>Folder Options>View>Hiden Files and Folders>hide file extensions of known File Types Then you would see that the Exported file has the CSV extension. Also, just open it with Notepad and take a look. > spreadsheet -- I don't understand why that is so. > Bernie > ----- Original Message ----- > From: "MikeB" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Saturday, June 14, 2008 7:34 AM > Subject: [RBASE-L] - Re: Gateway error importing .xls file > > >> Have you tried importing an "Excel WorkBook" as opposed to an "Excel >> SpreadSheet" ? >> >> >> ----- Original Message ----- >> From: "Bernard Lis" <[EMAIL PROTECTED]> >> To: "RBASE-L Mailing List" <[email protected]> >> Sent: Friday, June 13, 2008 9:08 PM >> 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 >>> >>> >> >> --- RBASE-L >> ================================================ >> TO POST A MESSAGE TO ALL MEMBERS: >> Send a plain text email to [email protected] >> >> (Don't use any of these words as your Subject: >> INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, >> REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) >> ================================================ >> TO SEE MESSAGE POSTING GUIDELINES: >> Send a plain text email to [email protected] >> In the message SUBJECT, put just one word: INTRO >> ================================================ >> TO UNSUBSCRIBE: Send a plain text email to [email protected] >> In the message SUBJECT, put just one word: UNSUBSCRIBE >> ================================================ >> TO SEARCH ARCHIVES: >> Send a plain text email to [email protected] >> In the message SUBJECT, put just one word: SEARCH-n >> (where n is the number of days). In the message body, place any text to >> search for. >> ================================================ >> >> >> > > >
