Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: ODBC getting Excel vartype wrong

From   "Steichen, Thomas J." <>
To   <>
Subject   st: ODBC getting Excel vartype wrong
Date   Tue, 25 Oct 2005 15:14:41 -0400


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?


Thomas J. Steichen
  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:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index