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/
