Statalist


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

Re: st: ODBC driver for Excel, <xmluse>


From   Arun Rajamohan <arajamoh@uwo.ca>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: ODBC driver for Excel, <xmluse>
Date   Thu, 27 Sep 2007 15:37:56 -0400

Hi,

ODBC driver from actual technologies <Actual ODBC Pack v 2.7 (for Mac OS X)> is what I have it does partially work - even though setting it up takes a bit of care. I use it to move user data between excel (csv), analyse it on stata and move it back to sqlite db. I can not say that I have had no issues.

Excel sheets can be read into stata after saving as csv files and using,
insheet using "~/desktop/xyz.csv", comma

One thing I learnt is that microsoft has not made it easy for others to export their files. Also see, http://www.stata.com/support/faqs/ data/newexcel.html

Hence the best bet is to use csv or even just copy the data from a xls sheet and paste it into stata worksheet. I understand (but not exactly) that if microsoft query is installed, then MS-excel can actually create a DSN containing excel files. Those excel files can be read by using
ODBC load "table name.xls" DSN("Excel files")

I have not had this magic happen yet. I am also waiting for someone who is done this (on mac would be more helpful) to elucidate this issue.

-A

On Sep 27, 2007, at 3:01 PM, DHF wrote:


Dear Statalisters,
Does anyone know where I can get an ODBC driver for Excel? I downloaded a trial from here <http://www.actualtechnologies.com/ products.php> for Access, and it seems to suggest that this should work for Excel as well, but I'm not sure. In any case, after downloading the package and adding a DSN linked to the Access driver and a specific .xls file, when I type <odbc list> in Stata, the list is empty. I am running Mac OS X and Stata 9.2. Also, I am having a problem with xmluse (another approach I am trying in order to read Excel worksheets into Stata) in that it keeps crashing Stata. Has anyone every encountered this?
Thanks,
Danielle
*
* 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/

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Arun Rajamohan PhD
Department of Biology
1151 Richmond Street North
The University of Western Ontario
London, ON N6A 5B7 CANADA

Tel: + 1-519-661-2111 ext 80582
Fax: + 1-519-661-3935
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

*
*   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