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
<[email protected]> 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: [email protected]
> [mailto:[email protected]] 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/
