[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 16:38:18 -0400

Here is what I have done,

In Mac OS X 10.4...

go to /applications/utilities/odbc administrator

add a new user dsn and use the driver actual access (must have actual technologies odbc driver installed - trial will copy only the first 3 rows of the dataset)

name it excel (you can use whatever name I guess) and point it to the excel database file in the ODBC access popup window.

Now ODBC list in Stata 10 (it might work with stata 9 as well). You will see excel (or the name you gave to the DSN) listed in it.

In stata,
odbc load, dialog(complete) dsn("excel") table("database name") or in stata menu -
File - Import ODBC data source - select the data source from the list

You should see the file and variable list.


Yet I think copying the the data from xls file straight into the Stata data editor is the best tactic (but of course it depends on your data type).

Hope it helps,

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
Room 237, Biological & Geological Sciences Building
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
[email protected]

Other contact numbers:
Home: 5192047680 / Cell: 5198511553

*   For searches and help try:

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