This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Significant data loss due to truncation from each record within the "Contents" string field.
I am trying to perform text analytics on the contents of an Outlook pst. file. I have exported the pst. into an Access database and have provided a list of the data fields below with my data loss occurring in the Contents field. Each record with the Contents field contains the information from the body or bodies (if email string). The size/length of each record ranges from a sentence to 20 plus pages worth of text. I need a way to import all the text contained in each record. I have checked the community and have already tried: auto field, select tool and increasing the data field size to 10,000,000; removing all duplicate white space, line breaks, etc.; setting the field type to string, vstring, vwstring, vwstring forced. I have 30 gigs of emails to get through so any help is very much appreciated.