Re: Excel File Import Error

From: Paul Matthias Diderichsen pmdi@novonordisk.com Subject: Re: [NMusers] Excel File Import Error Date: Wed, 30 Nov 2005 09:01:17 +0100 Dear Manoj, Could you provide a few lines of the datafile? You can mask out some digits, eg. YY.XXX (but only change numbers 0-9!), if data are sensitive. My (humble) guess would be problem with eiter "." being exchanged for "," (separator vs. floating point) or probs related to quoting character strings. My experience is, that XL (at least) sometimes manages to mess these things up good. Ultimately, there could be a problem related to character encoding as well (eg. UTF-8 vs. ISO-8859-1). Kind regards, Paul M. Diderichsen. _______________________________________________________