Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Stata & Databases


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Stata & Databases
Date   Mon, 3 Mar 2003 11:46:34 -0000

Giovanni Vecchi
> 
> I have been asked about a convenient way of transferring 
> data from Stata
> to external databases (say, Oracle) and viceversa.
> The only answer which comes to my mind is to use 
> Stat/Transfer, but I
> wonder if there are better protocols/procedures to handle this
> situation.
> 
> My second question is: can a query to an external database 
> be executed
> from within Stata? Is it a convenient procedure?
> 
> I would appreciate it if you could give me broad advice on the best
> practices to importing/exporting datasets from Stata to external
> databases and viceversa.

Among many other features for doing this: 

Stata 8 for Windows has an -odbc- command. 

Users of previous versions can read about it at 
http://www.stata.com/help.cgi?odbc

Nick 
n.j.cox@durham.ac.uk 
*
*   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