[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Excel->Text conversion
****** message to minivend-users from rho@Austria.EU.net (Robert Barta) ******
> ****** message to minivend-users from Ace Kumar <ace@digiknow.com> ******
>
>
> 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)
What about making the customer use .csv instead of .xls?
Our argument here is, that it is better to have a simple, non-proprietary
future proof exchange format.
Also, there is some confusion when the Excel contains several sheets.
\rho
-
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
