Text file (txt | csv)

An example setup, including a source file with downloadable data, for *.txt and *.csv text files is shown below.

Settings ConnectionString

ConnectionString=DRIVER=Microsoft Access Text Driver (*.txt, *.csv);DefaultDir=C:\Temp\Holixa ERP Picker Settings  

Settings ConnectionSelectCommand

ConnectionSelectCommand=SELECT * FROM txtData.txt

The column separator in the data file must be a comma ( , ).

Sample data file to download

txtData.txt

1KB

Open