Arjang, Excel is a wonderful data analysis tool but it is an EVIL data manipulation tool. It takes liberties with any values entered into cells and makes assumptions based on some fairly opaque rules.
it's not only Excel itself but users too, who can come in, after the fact and change data types at a whim. If your data source is Excel then you have to be extra vigilant in your validation before putting it into your database. There's really no other way, sorry :-( -- Regards, Neale NOON On 22 February 2011 08:04, Arjang Assadi <[email protected]> wrote: > On 21 February 2011 18:08, Andrew McGrath > <[email protected]> wrote: > > Using xlsgen to manage situation very similar to yours. Has worked very > well > > on a variety of projects. > > > > Website is at http://xlsgen.arstdesign.com/ > > > > Andrew > > Hi Andrew, > > How did you manage the data validation? There is pretty much no way of > enforcing business rules on any data being entered into excel. Doing > data validation and integrity checking after receiving it is a waking > nighmare. > > Is/Are there recomended practices of having some control over the data in > Excel? > > Regards > > Arjang >
