I'v come across another problem in my customer database that was implemented a while a go. During the importation process, the memo field in one of my tables is not importing all it's contents into the database. It truncates the data at about character, 240 or so. When the user looks at the data, the question that's been coming up alot is, where did it go.
The import process happens with vba code and is using the transfer text method with a spec file. if I do the process manually using the import menu and select the spec file, the entire contents of the memo field gets imported. What's going on here?