Comma separated file
A comma separated file is a plain text file with data. The data is organized into rows which are separated into values by the separator, normally a comma(hence then name Comma Separated Value, or CSV for short). To use CSV data, Select CSV as the data source type.
A CSV data source has the following settings:
Folder name
In this field you appoint the folder that holds the CSV file(s). Each file will be treated as a table. CSV files must have the extension .csv or .txt.
CSV file includes a header row
If your CSV file has a header row with field names make sure this checkbox is checked.
Select a table
In CSV data sources each .txt or .csv file in the specified folder is treated as a table. The table will be named after the file, with . replaced by #. For example, a file name customers.txt will result in a table named customers#txt.
Join multiple tables
Using the 'Join multiple tables' query method you can combine data from multiple files in the same folder.
For each selected table, you must specify the name of the table and the ID column.
The ID column is use to related rows in all tables.
Specify SQL statement
You can use basic SQL statements with CSV files, but keep in mind that queries on a text file evaluate much slower than on a database platform.
If your CSV file has a header row with field names, these field names can be used in SQL statements. If not, the fields are named F1, F2 and so on.
If your CSV file has a header row with field names, these field names can be used in SQL statements. If not, the fields are named F1, F2 and so on.
Example
A sample project that uses a CSV to generate a single document with a page per contact item in the CSV file can be found in Samples\CSV in the installation folder. Just double-click the .exe file and run the sample.
 | CSV files have no type information in them. When used, the database driver will guess the type of each column, based on the values in the column. This can result in e.g. SSN numbers being interpreted as dates and displayed incorrect. You can place a Schema.ini file in the same directory that contains your CVS files in order to specify the types (and names) of each column. For more information, go to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/ odbcjetschema_ini_file.asp. |