On Thu, Jun 13, 2002 at 01:47:03PM +0100, Aj McKee wrote:
> I am having a weird problem. I am trying to convert an Excel file to SQL. I
> was using Excel2Sql and it was working last week, but somehow now its not.
I don't know this script, so can't help much there. I'd suggest that you
have a look on the CPAN - putting 'Excel' in search.cpan.org turns up
quite a few things. The one I'd suggest is
Spreadsheet::ParseExcel::Simple (it should be easy enough to use). It
shouldn't be too hard to make it end up in your database using DBI or
Class::DBI. And the author supports his modules very well...
--
Russell Matbouli |
russell at futureless.org | I am Jack's raging bile duct
PGP KeyID: 0x3CA84CF4 |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mail.linux.ie/pipermail/webdev/attachments/20020613/99a0b07c/attachment.pgp
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
