Re: Excel->Text conversion

[Jeff Parker <Jeff.Parker@db.com>]

******    message to minivend-users from Jeff Parker <Jeff.Parker@db.com>     ******

ace@digiknow.com writes:
> Does anybody out there have a good MS Excel->Text parsing program (one
> that fixes all the crap that Excel does to a spreadsheet when saving as
> text)?
> 
> Since I have to take a client's Excel sheet, save it as text, and then
> import it into mSQL, all sorts bad things happen if I miss one of Excel's
> stupid quirks (and I can't use the EXCEL flag, as far as I know, since I'm
> not using ascii databases)

Have you looked at the Win32::OLE Perl module?  It lets you control
Excel directly from Perl, with objects and methods similiar to VBA, so
you could grab the data directly from within Excel.

There are some good examples in The Perl Journal, Issue 10.  The
example code is available here:

      http://orwant.www.media.mit.edu/tpj/programs/Issue_10_OLE/

Regards,
Jeff Parker

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list