st: Re: Insheeting Excel file with multiple worksheets

["Michael Blasnik" <michael.blasnik@verizon.net>]

Actually, you can't insheet a single Excel sheet either -- you need to save 
an Excel sheet as a tab or comma delimited file and then use insheet.  An 
alternative is to use Stata's ODBC.  For example:

odbc query "Excel Files;DBQ=c:\data\mystuff.xls"

will show you the worksheets available in mystuff.xls.  You can then:

odbc load, table("sheet2$") dialog(complete)

to import sheet2.

Michael Blasnik
michael.blasnik@verizon.net


----- Original Message ----- 
From: "Ms. Marilyn Ibarra" <ibarra@uga.edu>
To: <statalist@hsphsun2.harvard.edu>
Sent: Wednesday, August 16, 2006 3:32 PM
Subject: st: Insheeting Excel file with multiple worksheets



> I have data in an excel file with multiple worksheets.  Does anyone know 
> how to insheet the data into STATA without having to create separate excel 
> files for each worksheet??
*
*   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/