Driver Microsoft Text Driver.txt.csv Fmt Delimited
Note This topic provides Text File Driver-specific information. For general information about this function, see the appropriate topic under. SQLDriverConnect enables you to connect to a driver without creating a data source (DSN). The following keywords are supported in the connection string for all drivers: DSN, DBQ, and FIL.
Textfile connection strings. Driver = Microsoft Access Text Driver (*.txt, *.csv). Read Tab Delimited Text file using a Schema.ini into an Access database. Feb 23, 2014 Read a csv or txt file - Data and driver. ADO.NET Managed Providers Extended Properties='text;HDR=NO;IMEX=1;FMT=Delimited.
See More On Microsoft Docs
The following table shows the minimum keywords required to connect to each driver, and provides an example of keyword/value pairs used with SQLDriverConnect. For a full list of DRIVERID values, see.
