| ![](/includes/contimages/spacer.gif) |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: Insheeting Excel file with multiple worksheets
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
[email protected]
----- Original Message -----
From: "Ms. Marilyn Ibarra" <[email protected]>
To: <[email protected]>
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/