Import CSV Text files into DAO Recordsetiel

Hi all,

does anyone know where I can get a routine to open a std comma separated text file and import it into a DAORecordset,

thanks in advance,

Daniel

[ChrisD]

We use dao itself to open and read csv files, we put a flag in the record set class to say weather or not to opena mdb file or a csv file, we then define an operator= for the record set. We then create 2 instances of the record set 1 for mdb 1 for csv and then loop thru the csv records adding them to the mdb record. I don't have the code for this at home, but if you would like email me and I will send you a sample recordset and code for this.

HTH,
Chris