TOSQL: Stata module to transfer data to SQL database
Christopher Baum ()
Statistical Software Components from Boston College Department of Economics
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.
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)
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
Persistent link: http://EconPapers.repec.org/RePEc:boc:bocode:s417301
Ordering information: This software item can be ordered from
Access Statistics for this software item
More software in Statistical Software Components from Boston College Department of Economics Boston College, 140 Commonwealth Avenue, Chestnut Hill MA 02467 USA. Contact information at EDIRC.
Series data maintained by Christopher F Baum ().