I am trying to use the JET ISAM text driver to import a CSV file into an ADO recordset. The problem is that some of the field values (all quoted) contain nothing but spaces, I would like to preserve these spaces within the imported recordset but can't prevent them from being converted to nulls.
I have set up the necessary Schema.INI file but can't find any options that would prevent this behaviour.
Just as an aside how would you store nothing but spaces in an Access 2K text field!!