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
[email protected]
*
* 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/
