Problem with text field using imported data. (1 Viewer)

UniqueTII

What?
Local time
Today, 17:55
Joined
Apr 4, 2002
Messages
96
I have my database set up to import certain emails from my Outlook folders, and then break down the data in the emails into certain fields. This is done using a couple of queries. The problem is that the queries refuse to pass more than 255 characters of data for any of the fields. Two of the fields will almost always have more than this. Is there any way to set the field as a memo inside the query? I tried appending the data into a memo field in a table, but even though there was more than 255 characters, the query still treated the field as text and gave me a validation error. Is there any way around this? It has my whole project on hold right now.

Thanks in advance.
 

Users who are viewing this thread

Top Bottom