|
|  |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
RE: st: inexcel function?
My guess is that "inexcel" is some custom macro they had, that probably calls on the ODBC functionality of Stata that can call Excel files directly without messing around with converting them to .csv. See help ODBC, or see the link below for examples of what I *think* their "inexcel" command probably uses:
http://www.ats.ucla.edu/stat/Stata/faq/odbc.htm
Insheet is certainly useful for a one-way conversion into Stata, but when you need the files also to be manipulated using Access, Excel, etc. (potentially by other users who don't use Stata), then ODBC can be very powerful.
Ben Earnhart
________________________________
From: [email protected] on behalf of Clive Nicholas
Sent: Wed 12/13/2006 8:50 PM
To: [email protected]
Subject: Re: st: inexcel function?
Don McCarthy wrote:
> I received a programme with this code:
>
> inexcel using "$heeb/Data/DEM.xls", sheet("actual")
>
> I am not familiar with any such function "inexcel" - has any user heard of
> it?
No such command is turned up via -findit-. However, there is a command
called -insheet- which you can use for converting MS Excel files into
Stata (assuming that's what you want to do). You'll need to convert the MS
Excel file into .csv format first. See -whelp insheet- for more.
CLIVE NICHOLAS |t:
Politics |e: [email protected]
Newcastle University |http://www.ncl.ac.uk/geps
Whereever you go and whatever you do, just remember this. No matter how
many like you, admire you, love you or adore you, the number of people
turning up to your funeral will be largely determined by local weather
conditions.
*
* 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/
*
* 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/
