in reply to Re: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode
in thread Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode

Why not skip the XML and just use DBD::ODBC or DBD::Excel to read the Excel file directly?
Because the data extraction process is complicated, and I've already done it. There are many guidelines to be stretched as needed, and there are a couple of different versions of these files, to which I've already built a uniform interface

cheers anyway!


davis
It wasn't easy to juggle a pregnant wife and a troubled child, but somehow I managed to fit in eight hours of TV a day.
  • Comment on Re^2: Mildly OT: Excel Order Forms -> XML -> MySQL -> HTML with unicode

In Section Seekers of Perl Wisdom