Tuesday, February 28, 2006
Re: st: Excel ODBC Driver for Mac
Let me preface by saying that I've never used ODBC in Stata:
Nevertheless, hopefully I can provide some assistance.
I recommend reading the following links, as well as attempting to utilize OS X's native ODBC application. Assuming you are running OS X >= 10.2, X's ODBC administration utility can be found in / Applications/Utilities/ODBC Administrator.
A clunky work around, if you don't understand the ins and outs of ODBC, would be to save your Excel 2004 Workbook locally in .xml format and -xmluse- each worksheet you want to port into Stata. You may find this cumbersome as you'll find yourself needing to do this each time your DataBase changes, but you could probably program an AppleScript, Automator script, or VisualBasic Macro within Excel to do this for you and then call up a .do file to make the desired revisions to your Stata .dta file.
I recommend the following links for more information about ODBC using OS X, Excel, and Stata:
http://www.stata.com/support/faqs/data/odbcmu.html http://www.ats.ucla.edu/stat/stata/faq/odbc.htm http://www.microsoft.com/mac/products/excel2004/using.aspx? pid=usingexcel2004&type=howto&article=/mac/LIBRARY/how_to_articles/ office2004/xl_ODBC.xml http://www.openlinksw.com
On Feb 26, 2006, at 12:37 PM, Danielle H Ferry wrote:
> Hi, > Does anyone use the <odbc> command to read data into Stata 9 from > Excel 2004 (on an OS X box)? Where can I find the appropriate > driver and how do I install it? > > -- > Danielle H Ferry > > > * > * 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/
Links to this post: