This is a 2 part problem. (I don't write code and I pasted an example of what happens at bottom.)
1) I download data from a database that creates a .csv file. I have a column in the file that is a text narrative with a large length (quite often longer than 255). I save the file as an .xlsx file and the narrative remains ok at this point (lengths of >255 are unchanged).
2) I import the .xlsx file to a .accdb (access 2007) database where the column is imported as data type "memo" and the length remains unchanged.
Now I run queries against the data and do things with them.

issue (1) I did a "make table" query in Access of the fields I wanted (including the narrative) and the data type for the narrative remained "memo" BUT the narrative now has for some reason been limited to 255 in my new table. (so I can't make a table from the data and simply export it.)

issue (2) if I run a query from the original imported data in Access and copy the results to an excel spreadsheet it will limit my narrative field to 255 and I have to go cell by cell to my original data in access or in the original excel spreadsheet and copy the results into each cell so I don't lose the additional narrative. However the query itself still contains the unchanged narrative length.

Any help for issues 1 & 2 would be appreciated - I need the narrative lengths to remain the same between all sources and I can't do a cell by cell copy and paste to get the length back.

Both Access and Excel are 2007. Below is a copy of how it varies...

Same narrative
Xxxxx was going to trash can and slipped on water in the room. She fell on her left wrist and left knee, no injury, contusion, deformities noted; she is able to move extremities w/o difficulty noted, she ambulated back to her mothers chair at the window bed area w/o difficulty.
Denies need for emergency room treatment at this time, states if she has pain tomorrow, she will follow-up with her own M.D.
Length = 404
Source = Original in .csv and same as in .xlsx first save and same as in access database - and what I copied from the cell in my query

Xxxxx was going to trash can and slipped on water in the room. She fell on her left wrist and left knee, no injury, contusion, deformities noted; she is able to move extremities w/o difficulty noted, she ambulated back to her mothers chair at the window
Length = 255
Source = what came over after I copied in batch from the access query and pasted into excel