[ Up: Operation Reference ]

Creates an SQLTable from the contents of a Comma Separated Value (CSV) file. Records can then be extracted / insert from / to this table using regular SQL queries.

Default label: "Create SqlTable from CSV File"
Member of plug-in: Data analysis
Catalogue path: Database

Inputs:
File name	QString
Delimiter	QString	Delimiter must be a single character
Column headers	CSIRO::DataAnalysis::CreateSqlTableFromCsvFile::ColumnHeaderFormatting
Determine datatypes	CSIRO::DataAnalysis::CreateSqlTableFromCsvFile::DetermineDatatypes	Controls whether to use the first row or all rows to determine cell data types.
Skip top # lines	int
Table name	QString
Database	QSqlDatabase	Optional: database to use - if none is specified then a new database will be created.
Log info	bool
Outputs:
Database	QSqlDatabase
Table name	QString