> That is a solution for Stata->Excel, but Ashim asked about Excel->Stata.
I
> tried to replicate his problem, and it did not happen to me... Anything
> special about that string variable that we should know about, Ashim?
Have
> you tried to -insheet- instead of pasting?
Right! I missed that. I would try - insheet- as Martin suggests; -odbc-
may also help
h odbc
Johannes
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Johannes
Geyer
> Sent: Wednesday, October 01, 2008 3:41 PM
> To: [email protected]
> Subject: Re: st: space trouble in excel to stata conversion
>
> "here is what I do, I copy and paste a string variable from excel to
> stata ( ie. a column of observations from excel to stata). For some
> strange reason there is a SPACE after each observation which refuses
> to go away even after I use the -trim- command.
> Has anyone experienced this ? Please tell me if I can read about this
> somewhere."
>
> I don't know - you could do the following and avoid that problem:
>
> *********************
> sysuse auto
> xmlsave make using FILENAME, replace doctype(excel)
> *********************
>
> Johannes
>
>
>
>
> ----------------------
> Johannes Geyer
> Deutsches Institut f�r Wirtschaftsforschung (DIW Berlin)
> German Institute for Economic Research
> Department of Public Economics
> DIW Berlin
> Mohrenstra�e 58
> 10117 Berlin
> Tel: +49-30-89789-258
>
>
>
>
>
> *
> * 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/
>
>
> *
> * 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/
*
* 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/
