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/
