[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Stata & Databases
Giovanni Vecchi <email@example.com> 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.
* For searches and help try: