TOSQL: Stata module to transfer data to SQL database

Christopher F Baum ()

Statistical Software Components from Boston College Department of Economics

Abstract: tosql facilitates the transfer of selected variables and observations to an SQL database via the INSERT statement. It handles missing values, casewise deletion, and properly quotes string values for SQL use. It has been tested with the mySQL database. Optionally it will write the table creation script. The routine has been rewritten to utilise the new file command in Stata. Stata 6 users should use tosql6.

Language: Stata
Requires: Stata version 7.0 and file command
Keywords: data handling; database (search for similar items in EconPapers)
Date: 2001-03-18, Revised 2001-05-31
Note: This module may be installed from within Stata by typing "ssc install tosql". Windows users should not attempt to download these files with a web browser.
References: Add references at CitEc
Citations Track citations by RSS feed

Downloads: (external link)
http://fmwww.bc.edu/repec/bocode/t/tosql.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/t/tosql.hlp help file (text/plain)
http://fmwww.bc.edu/repec/bocode/t/tosql6.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/t/tosql6.hlp help file (text/plain)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: http://EconPapers.repec.org/RePEc:boc:bocode:s417301

Ordering information: This software item can be ordered from
http://repec.org/docs/ssc.php

Access Statistics for this software item

More software in Statistical Software Components from Boston College Department of Economics
Address: Boston College, 140 Commonwealth Avenue, Chestnut Hill MA 02467 USA
Contact information at EDIRC.
Series data maintained by Christopher F Baum ().