Dan, Can you save the Excel worksheet as a text, space delimited file?
If you can, try the LOAD AS FORMATTED command - doesn't matter then if there are embedded quotes or commas, just specify the column name and the start and end position in the file. Before you save the worksheet make shur you have changed to a mono spaced font and ensure that the column widths are all set to allow the width of all data in each column. Regards Clive Williams Sydney Australia ----- Original Message ----- From: "Dan Weissmann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 10, 2001 5:46 AM Subject: Re: The Data Conversion from Hell > Tried 'em all. The only other thing that seems to work is dbase, but that's > limited to 128 columns. Amazing, that Excel 2002 has so few "save as" > capabilities. > > > ----- Original Message ----- > From: "Nicky Avery" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, October 09, 2001 10:26 AM > Subject: Re: The Data Conversion from Hell > > > > > > > > Dan Weissmann wrote: > > > > > > As it > > > is, I'm already having to pull the data from Sybase into Excel. > > > > Does Sybase not export in other formats common with R:Base such as WKS, > > WK1, DIFF, SYLK? I've found they can work when other more modern formats > > fail. > > > > HTH > > > > Nicky > > > > > >
