st: Appending several excel data sets into one

["Patrick Musonda" <pmuzho@hotmail.com>]

Dear Stata List,

I am working on a project where we get excel data that has several sheets, 
for example:

data.xls-sheet1, sheet2, sheet3, etc
data.xls-sheet1, sheet2, sheet3, etc
data.xls-sheet1, sheet2, sheet3, etc
.
.
.
datan.xls-sheetn1, sheetn2, sheetn3, etc

We have several of such data sets, over n=200, say. Of these excel data 
sets, we are only interested in one sheet, say sheet2. How can one append 
these several sheet2s in one stata data sets in a simple program short of 
coping one at a time and then appending them?

Your help will be highly appreciated,

Best wishes,

Patrick.

_________________________________________________________________
The next generation of Hotmail is here!  http://www.newhotmail.co.uk

*
*   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/