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

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


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