csvToSql :: comma separated value conversion tool and library

Name	SqlInsertRenderer
Class	net.sf.csv2sql.renders.SqlInsertRenderer
Description	Create sql insert statements reading data from csv file
Authors	Davide Consonni (dconsonni AT enter.it)
Required parameters
name	description
inputfile	the of the csv file containing data.
separator	separator of csv data. special chars like (\t) can be used.
Optional parameters
name	description
trimdata	true or false. trimdata remove blank spaces from csvdata.
suppressheader	true or false. csv data can contain a header, this option suppress first line of csvdata.
removedoublequotes	true or false. remove the (") from csv data.
idGenerator	an id generator. add the column "id". see table of idgenerators for the list
presql	statement to run BEFORE inserts
postsql	statement to run AFTER inserts
skiplines	number of lines to skip
splitter	the splitter of data see splitters table for the list
acceptwrongrows	don't throw RendererException if number of value and fields differs
suppresstrailingsemicolon	remove semicolon at the end of statements

Name	SqlInsertRendererFromArray
Class	net.sf.csv2sql.renders.SqlInsertRendererFromArray
Description	Create sql insert statements reading data from any java.util.List implementation.
Authors	Davide Consonni (dconsonni AT enter.it)
Required parameters
name	description
inputfile	the of the csv file containing data.
separator	separator of csv data. special chars like (\t) can be used.
Optional parameters
name	description
trimdata	true or false. trimdata remove blank spaces from csvdata.
suppressheader	true or false. csv data can contain a header, this option suppress first line of csvdata.
removedoublequotes	true or false. remove the (") from csv data.
idGenerator	an id generator. add the column "id". see table of idgenerators for the list
splitter	the splitter of data see splitters table for the list
acceptwrongrows	don't throw RendererException if number of value and fields differs

Name	SqlInsertRendererFromDBF
Class	net.sf.csv2sql.renders.SqlInsertRendererFromDBF
Description	Create sql insert statements reading data from a DBF archive.
Authors	Davide Consonni (dconsonni AT enter.it)
Required parameters
name	description
inputfile	dbf archive containing data.
Optional parameters
name	description
trimdata	true or false. trimdata remove blank spaces from csvdata.
idGenerator	an id generator. add the column "id". see table of idgenerators for the list
presql	statement to run BEFORE inserts
postsql	statement to run AFTER inserts

Name	SqlInsertRendererFromExcel
Class	net.sf.csv2sql.renders.SqlInsertRendererFromExcel
Description	Create sql insert statements reading data from excel file.
Authors	Davide Consonni (dconsonni AT enter.it)
Required parameters
name	description
inputfile	the of the csv file containing data.
Optional parameters
name	description
trimdata	true or false. trimdata remove blank spaces from csvdata.
suppressheader	true or false. csv data can contain a header, this option suppress first line of csvdata.
removedoublequotes	true or false. remove the (") from csv data.
idGenerator	an id generator. add the column "id". see table of idgenerators for the list
startrow	start line number
stoprow	stop line number
skipfields	blank separated list of field to skip
presql	statement to run BEFORE inserts
postsql	statement to run AFTER inserts