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

Re: st: Stata & Databases

From   Philippe Glaziou <>
Subject   Re: st: Stata & Databases
Date   Mon, 3 Mar 2003 18:58:38 +0700

Giovanni Vecchi <> wrote:
> I have been asked about a convenient way of transferring data
> from Stata to external databases (say, Oracle) and viceversa.

stata -> sql database

   You may check the package -outdat- from ssc. 

sql database -> stata

   sql database=# COPY [table] TO '/tmp/filename';

   I usually process '/tmp/filename' with awk to replace tabs and
   spaces with a comma delimiter, and then -insheet-
   '/tmp/filename' in stata. I find this procedure convenient.

Philippe Glaziou
*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index