For years I take a customers excel file and import it into access and then it is used with older classic asp coding. Everything has worked fine, but now for whatever reason when I import the excel file into MS Access there is one field that should be "MEMO" and it imports it as a MEMO field, but still cuts the text off at 255 characters. I tried saving the excel file to a text file and doing the same thing, but it makes no difference. I have probably spent close to 3 hours now on this. I searched google, but it seems that other people have this problem too, but not sure what the solution is. Anybody?