DBD::Excel itself may not have changed much, but there may not be much to change (I don't use Excel so I don't know) . But it's just a shim between SpreadsheetParseExcel and SQL::Statement and DBI and all of those modules have changed. Unless you need to do manipulation of the spreadsheet or complex queries, it should be sufficient for this task. If you're reading from one database and writing to another, it makes sense to do it all in DBI. If DBD::Excel isn't suitable, then you can declare Excel as an ODBC DSN and use DBD::ODBC on it.

In reply to Re^2: Reading from Excel and writing to Oracle by jZed
in thread Reading from Excel and writing to Oracle by loris

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.