MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: CSV to XLS(x)



fixed

I would like to mention one more thing:

It's better to convert physical files (or database tables) directly to
Excel, rather than doing the intermediate step of CSV. Besides
efficiency (why do an unnecessary step?) there is also the issue of
data types. When you convert to CSV, you lose your type information.
Excel doesn't have a lot of types, but at least it makes a distinction
between numeric and character data, and it's easier to just use the
type information from the file than trying to deduce the type from CSV
data.

Also note that Excel doesn't really have a separate date/time data
type. It just uses numeric, but with special formatting.

John





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact