NotesSQL & Text List Data Types using MS Access

HCL Domino Domino Forum
1

I have a Text List field called CompanyName.When I export data from a Lotus Notes database, it exports a separate record for each CompanyName in the List.

However, when I use NotesSQL to connect the database to MS Access, it only creates one record and puts the entire Text List into one record into a memo field in MS Access.

  1. Can I adjust the NotesSQL driver so it creates a record for each item in the Text List field? If not,

  2. Is there a way I can count the number of entries in that Text List when connecting with the NotesSQL driver?