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

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

From   Arun Rajamohan <[email protected]>
To   [email protected]
Subject   Re: st: ODBC driver for Excel, <xmluse>
Date   Thu, 27 Sep 2007 15:37:56 -0400


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, 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.


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 < 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?
* For searches and help try:

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:

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