Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Re: why -odbc- made error?


From   "Joseph Coveney" <jcoveney@bigplanet.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: why -odbc- made error?
Date   Fri, 31 Jul 2009 02:17:14 +0900

Rose wrote:

When I type,
odbc load,dsn("Excel Files;DBQ=xx.xls") table("1998$")
list

The result window of stata shows as follows,

     +---------------------------------------------+
     |      code   indname   x   y   z   a   b   c |
     |---------------------------------------------|
  1. | 000877.SZ    徐永平   .   .   .   .         |
  2. | 600811.SH    关国亮   9   7   1   .         |

[redacted]


However, in fact my data is as follows,

     +---------------------------------------------+
     |      code   indname   x   y   z   a   b   c |
     |---------------------------------------------|
  1. | 000877.SZ    徐永平   .   .   .   .   .   . |
  2. | 600811.SH    关国亮   9   7   1   .   .   . |

[redacted]

Namely, there is something wrong with variable c.
Could anyone tell me why?

--------------------------------------------------------------------------------

Yes:  Excel.

This comes up periodically on the List.  For a workaround, see

www.stata.com/statalist/archive/2006-08/msg00457.html

or

www.stata.com/statalist/archive/2007-09/msg00510.html

Joseph Coveney




*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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