CSV files
For Text and CSV files the Data source properties dialog permits the file containing the data sheet to be selected using the Browse button
Note that the name of the file does not appear in the connection string – only the path to the folder containing the file. The filename is place in the Recordset/Query string
Select * from test.csv
returns all the data from the file test.csv. Note also that AnyLabels assumes that the fieldnames are provided in the first row of data in the file. If no fieldnames have been provided in the file then unchecking the ‘Source provides fieldnames’ box will cause the fieldnames to be set to Column1, Column2, etc. but will still result in the first line of the file NOT appearing as data.