Problem – While reading a CSV file using Microsoft Text Driver, It interprets CSV file columns in it’s own way like if one the column contains data specific to a date, then it only keep data which is in proper format otherwise it put null against that. Solution – Create a schema.ini file which defines the structure of a CSV file in turn gets interpreted automatically by driver itself in a desired format. Details – Schema.ini files provide schema information about the records in a text file. If you create a DSN, the schema.ini file gets created automatically in the
Continue reading