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

[Arun Rajamohan <arajamoh@uwo.ca>]

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/