Giovanni Vecchi <[email protected]> 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:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
