Excel import from Access truncates memo fields

In excel if you import external data from an access table that has memo types, it will truncate to 255 characters.

To solve, simply change the query type to SQL instead of Table. On the main Import Data form, select "Edit Query". In the drop down where it says Table and change it to SQL. In command text enter whatever SQL query you want (example: select * from tablename)

I don't know how many characters it will import or display, but it's more than 255 and enough for what I was doing...