I know there are MANY posts related to the subject of bringing Notes data into Access, but I have not yet found a resolution to the issue I am having. Thanks in advance for any assistance you can offer.
I have a Notes document (Communication) that has an RTF field which is the "body". I do have a hidden field on the form that is the "text" version of the body field, using @Abstract to convert the RTF field contents to text.
I have an access db with a table (btd_comm) containing the fields on the Communication form. I also have an ODBC data source set up; max length of RTF is 64994.
I need to pull ALL of the data from the RTF into this access db so that I can in turn pass it to another developer for inclusion into a re-write of the original db (non-notes). The column in the table that is intended to hold the RTF is of MEMO type.
I am NOT an access developer, so this is a whole new thing for me. I have not found any way that I can directly load all of the data from the Notes db into access. I have tried doing "Load External Data - Import" as well as "Load External Data - Link Tables" and do not have any success. Each time I attempt to accomplish this task, a completely new table is created.
So, how can I (a) get teh data directly loaded into the btd_comm table I created and (b) how can I get this stupid RTF field to come across?
Thanks again for your help.