importData from excel files

["Jonathan Dakin" <jdakin@overwey.demon.co.uk>]

Dear Users,

I've have a large number of excel files which I need to import into Splus.  (Each is a daily diary card).  I'm getting very unpredictable results when there are blank cells in the Excel file.  Quite often Splus substitutes:  "\240\240\240\240\240" where there should be a blank, or NA.

There is no very easy way of removing the blanks, without going through hundreds of spreadsheets and modifying each.  Exporting each to a text file would be equally as arduous.  The only solutions I've found in the archive of the mailing list involve one of the above.

Does anyone know of a work-around or a solution to this ?  I'm using Splus 6.1 Professional under W2K.

Many thanks and any help much appreciated.