[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.
----- Original Message -----
From: "Ms. Marilyn Ibarra" <firstname.lastname@example.org>
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: