CSV

The CSV driver is capable of loading CSV files into the InMemory Database.

Connection String Parameters:

Keyword 

Value

Description 

HasHeaders

true/false

Flag for whether the file has a header as the first row or not.

loadasstring

true/false

Flag for the driver to perceive all rows as being strings and thereby not interpreting data types

type 

local/url

Use 'local' if the file is placed on the local file system.  The driver also supports retrieving data from a regular URL without password protections

delimiter

;

Sets the delimiter character. The string quotes are automatically detected

encoding

Windows-1252

Determines the character set. The encoding specified must be in the list of encodings available in the .NET API

Query parameters:

Retrieving the data from the file is done by performing a SELECT command, e.g.

SELECT * FROM [sample_csv_file.csv]

The driver does not support retrieving individual columns. If this is required the solution is to load the data into another table after the import finishes.

Example:

LOAD ASSEMBLY 'TARGIT.Csv.dll' 
DATASOURCE [CSV] = DOTNET CONNECTION 'TARGIT.CSV.CsvConnection'
'HasHeaders=true;loadasstring=true;type=local;delimiter=;;encoding=Windows-1252;'

IMPORT [BudgetData] = [CSV].{SELECT * FROM [C:\DEMODATA\BUDGETDATA.CSV]}
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.