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

[Arun Rajamohan <arajamoh@uwo.ca>]

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,
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
> 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
> arajamoh@uwo.ca
> http://homepage.mac.com/arunrajmohan/
>
> Other contact numbers:
> Home: 5192047680 / Cell: 5198511553
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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