Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: Importing data from excel with multiple worksheets


From   "Rijo John" <rmjohn@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Importing data from excel with multiple worksheets
Date   Fri, 23 May 2008 11:15:19 -0500

Thanks Phillip and Martin. Let me go through the help and see if I can
figure this out.

Rijo.

On Fri, May 23, 2008 at 10:47 AM, Martin Weiss
<martin.weiss@uni-tuebingen.de> wrote:
> Try -xmluse- which allows specification of a specific worksheet. Hold the
> data in -tempfile-s and later append them one after another.
>
> Martin Weiss
> _________________________________________________________________
>
> Diplom-Kaufmann Martin Weiss
> Mohlstrasse 36
> Room 415
> 72074 Tuebingen
> Germany
>
> Fon: 0049-7071-2978184
>
> Home: http://www.wiwi.uni-tuebingen.de/cms/index.php?id=1130
>
> Publications: http://www.wiwi.uni-tuebingen.de/cms/index.php?id=1131
>
> SSRN: http://papers.ssrn.com/sol3/cf_dev/AbsByAuth.cfm?per_id=669945
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Rijo John
> Sent: Friday, May 23, 2008 5:23 PM
> To: stata
> Subject: st: Importing data from excel with multiple worksheets
>
> HI,
>
> I have  an excel file with many worksheets all of which contains same
> set of variables but representing different states. Instead of copying
> and pasting all of them one by one into stata and later stacking
> different stata files, is there an easier way to stack all the excel
> sheets into one data and export it to stata?
>
> Thanks,
> Rijo.
> *
> *   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/
>
> *
> *   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/
>
*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index