TOSQL: Stata module to transfer data to SQL database
Abstracttosql 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.
Download InfoIf you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
Bibliographic InfoSoftware component provided by Boston College Department of Economics in its series Statistical Software Components with number S417301.
Programming language: Stata
Requires: Stata version 7.0 and file command
Date of creation: 18 Mar 2001
Date of revision: 31 May 2001
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.
Contact details of provider:
Postal: Boston College, 140 Commonwealth Avenue, Chestnut Hill MA 02467 USA
Web page: http://fmwww.bc.edu/EC/
More information through EDIRC
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Christopher F Baum).
If references are entirely missing, you can add them using this form.