Roland Dumas at [EMAIL PROTECTED] wrote:
> What's the format of the resultset that will cause each field to fall into a
> column and for each row to fall into an excel row?
I just write the ResultSet to a file with the extension '.xls' so it opens
in Excel.
There are some interesting issues with Excel though. If it sees a big number
(like 16 digits, the size of a credit card number) it loves to assume they
are numeric and writes them in scientific notation (1234123412341234 becomes
1.2341e+15) and MM/YY dates become MM/YY/<this year>. The best way to handle
it is to have four fields for CC number and two for expiry and then parse
the values before writing them
Wayne
Byte Services Pty Ltd
http://www.byteserve.com.au/
[EMAIL PROTECTED]
Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
