I ran into this recently while moving data from one Excel spreadsheet
to another using VBA. It appears the limitation is 255 characters. In
Access you can look at the table design and deterimine if the field
type is Memo (possible 65,535 char) or Text (max 255 char).

If it is Memo then you would probably be better off manipulating the
data in Access by creating a new query and then export it to Excel.
You said that you can't export a query Access, but you can export the
results to Excel.

From Access:
-Click File Save As/Export (Maybe File Export, Depending on the
version of Access)
-If you get the Save As/Export choose to external File and Click OK.
-If you get File Export, next Step
-You'll see the Export or Save As dialog box. In the "Save as type:"
dropdown box at the bottom choose Excel.
-Now click Export.

HTH,
Stan