I have created a table that gets it's data from a .xls file using a select all and cut from Excel 2010 and paste into my table in Access 2010. I have a cell that contains typed text that may be anywhere from 0 to a few thousand characters. In Access I set that field to memo which i thought would allow more than 255 characters.
My problem is that sometimes the memo cell will cut off the characters and not paste the entire contents. I can copy from Excel the single (for example) 500 character cell into Access and it will copy the full thing.
Any idea's how I can make the contents of the Excel file be mirrored in Access exactly?