Have you looked at
http://www.stata.com/support/faqs/data/newexcel.html ?
In addition, Stata sometimes gets confused by " characters
within spreadsheet fields.
Nick
[email protected]
Andrea Molinari
> I have a very simple (?) question, in the hope of getting any
> suggestions....
> While transferring data from Excel onto Stata (using
> Stat/Transfer v.5), my
> .dta file has a couple extra rows and three more variables
> which are NOT in
> my excel file. If I de-select these three variables, then the
> data on my
> first variable (which is a string) disappears.
> I tried by copying all the data in values on a new
> spreadsheet but the same
> thing happens... I am puzzled because this did not happen to me before
> (using the SAME database!)
*
* 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/
