Listers,
I ran into a second ODBC problem. I have a column in Excel whose cells
are formatted as text but is being read by ODBC as number. Most of
the cells in the column are of the form 1234567.8 (which is why the
error occurs) but some are of form 1234567.t9, and these are set to
missing when transferred to Stata. Recovering this information in
Stata, once the value is set to missing, is impossible, so the
question is, how to force ODBC to honor the text format in Excel?
Tom
Thomas J. Steichen
[email protected]
----------------------------------------------------------------------------
Facts do not cease to exist because they are ignored. - Aldous Huxley
----------------------------------------------------------------------------
-----------------------------------------
CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s),
contains information that may be confidential, protected by the
attorney-client or other legal privileges, and/or proprietary non-
public information. If you are not an intended recipient of this
message or an authorized assistant to an intended recipient, please
notify the sender by replying to this message and then delete it from
your system. Use, dissemination, distribution, or reproduction of this
message and/or any of its attachments (if any) by unintended recipients
is not authorized and may be unlawful.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
