On Thu, 2001-11-29 at 23:37, Tom Servo wrote: > There's probably a far better answer to this than I can give, but if not, > an interim solution might be having whoever maintains these Excel files > save them as .csv files. Excel can do that, and while you lose all the > fancy formatting, it just dumps them in a comma seperated list, then you > can split on commas to get the values out of it.
Be careful, MScsv is not as simple as it seems. Fields containing , are enclosed in "" - thats OK. But those ""-enclosed fields saved from Excel can also contain linebreaks. Hth, Joachim