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." <SteichT@rjrt.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: ODBC getting Excel vartype wrong
Date   Tue, 25 Oct 2005 15:14:41 -0400

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
steicht@rjrt.com
----------------------------------------------------------------------------
  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/



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