I also prefer the LOAD rather than Gateway. I also recommend using TAB as the field delimiter. I find less trouble with embedded commas.
Bill Cook Kent WA USA ----- Original Message ----- From: "Ian Chivers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 09, 2001 1:40 AM Subject: Re: The Data Conversion from Hell > i've had difficulties in the past with using gateway. > > what i found to be most reliable was the suggestion made > by a number of people to use > > load table as filename as ascii > > from the r prompt. > > i make sure that the file is comma separated with quotes. > > hope this helps. > > On Mon, 8 Oct 2001 13:38:52 -0500 Texmaster Express > <[EMAIL PROTECTED]> wrote: > > > Good afternoon. > > > > I'm still working on the data conversion routine from Hades. I've decided to > > use the Gateway command since it seemed to work once before. I've saved my > > Excel file to an XLS3 format (am using Excel 2002) and run the command: > > > > gateway import xls3 ords.xls replace orders > > > > I've also tried a variant of the above, > > > > gateway import xls3 ords.xls create x > > > > In each instance, R:Base returns the error message: > > > > Cannot import a table with 0 columns > > > > I've checked my source table in Excel and it reads just fine. I've also > > checked to be sure I have an equal number of columns. > > > > I've also tried saving the file as a dbf, attaching it and projecting it, > > but the Excel file has 169 columns, and the dbf file will only allow 128. > > > > Any suggestions? (Besides convincing our software company to use Oterro, > > which I've already tried) > > > > Dan > > > > -- > > Ian > > [EMAIL PROTECTED] > > Home page > > http://www.kcl.ac.uk/kis/support/cit//fortran/ > > comp-fortran-90 home page > > http://www.jiscmail.ac.uk/lists/comp-fortran-90.html > >
