jebushatescats
IS-IT--Management
Hello all
I have an existing application that imports a csv file and loads it into a access DB. The users want to be able to include commas in the field values so I have decided to read in the file using ADO to split up the fields. I have this working except for one problem. It appears as if when I try to assign a field value fromm the csv file greater than 255 characters in length, ado drops the value and assigns a null value to the recordset field.
How can I import from a csv file using ado fields that are greater in length than 255 char's.
I have an existing application that imports a csv file and loads it into a access DB. The users want to be able to include commas in the field values so I have decided to read in the file using ADO to split up the fields. I have this working except for one problem. It appears as if when I try to assign a field value fromm the csv file greater than 255 characters in length, ado drops the value and assigns a null value to the recordset field.
How can I import from a csv file using ado fields that are greater in length than 255 char's.