accessing multi-value field data from Sharepoint

[Eric]

How do sharepoint multi-value field data from within Access 2007? I can link
tables and work with the field values for Attachments - a boilerplate
Sharepoint multi-value field. However, custom fields created in a Sharepoint
list only allow access to the last entry made.

 

[Eric]

Specifically, my problem is with multi-line text columns. Sharepoint seems to
keep a text value, a created by value and a created date/time value. For
look-up data type multi-value field, you do get access to the multiple data
values. However, for the text or field type, you only seem to get the last
entry.