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 18:59:32 -0400

Hi Danielle,

The ODBC driver can load an .xls file and each sheet would appear as a separate datasheet and the variables would also be listed for each selected sheet. I did a mock run using a mock xls sheet. I have posted the stata screen shot showing the commands at,

http://publish.uwo.ca/~arajamoh/screen1.png

Only issue I suspect in your case is the trial driver that you have. When I used trial ODBC driver some times back it was buggy.

Hope this helps you.

-Arun

On 27-Sep-07, at 5:22 PM, DHF wrote:


Arun,
Thanks for replying. What you describe is what I did, and <odbc list> gives me a blank list. But now I am wondering: the Excel file I am linking the driver to has a ".xls" extension. Should it be something else? (Also, I've done the whole CSV thing, but it's not a realistic possibility for the number of worksheets and workbooks I have and having to update the data every quarter.)
Danielle

On Thursday, September 27, 2007, at 01:40PM, "Arun Rajamohan" <arajamoh@uwo.ca> wrote:

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/


*
*   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
Postdoctoral Fellow
Department of Biology
Room 360, Biological & Geological Sciences Building
1151 Richmond Street North
The University of Western Ontario
London, ON N6A 5B7 CANADA

Office: + 1-519-661-2111 ext 80582
Office Fax: + 1-519-661-3935
Home: 5192047680
Cell: 5198511553

arajamoh@uwo.ca
homepage.mac.com/arunrajmohan/




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