Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: Insheeting Excel file with multiple worksheets


From   "Michael Blasnik" <michael.blasnik@verizon.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: Insheeting Excel file with multiple worksheets
Date   Wed, 16 Aug 2006 15:55:51 -0400

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index