I am trying to export data from a LotusNotes database into MS Access. The Notes database that I am exporting does not contain a view with all of the pertinent information. (Otherwise this would be easy!) The only export feature I've found so far that will export the data from the documents (as opposed to view) is the Structured Text format. However, because the Structured Text format file would look like:
field1: data
field2: data
field3: data
instead of the spreadsheet/crosstab format, I can't devise a method of importing the file into Access.
Can anyone help me?
field1: data
field2: data
field3: data
instead of the spreadsheet/crosstab format, I can't devise a method of importing the file into Access.
Can anyone help me?