Thank you. I will try that and get back to you.
Ashim.
On Wed, Oct 1, 2008 at 7:31 PM, Johannes Geyer <[email protected]> wrote:
>> 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/
>
*
* 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/
