Reply to post: Bloody Excel

Extract, transform, load? More like extremely tough to load, amirite?

Ken Moorhouse Silver badge

Bloody Excel

If Excel is in the mix somewhere then there's usually problems. Either with leading zeroes being removed, telephone numbers appearing in scientic notation (having first succumbed to leading zero removal), or dates being dealt with inconsistently (UK dates). One reason I use OpenOffice is that it actually asks you what kind of data you are working with.

Also being a UK philistine we're in our comfort zone with the base ASCII table, so programs that "autocorrect" words like cafe to the accented version are a pain too when trying to feed into a program that doesn't accept them.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon


Biting the hand that feeds IT © 1998–2020