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

[Arun Rajamohan <arajamoh@uwo.ca>]

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/