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

1KB
txtData.txt
PreviousExamples of connections to data sourcesNextMS Excel

Last updated