Access / Excel 2007 I have a problem with data being truncated when pasted / exprted out of Access
Posted on 2009-04-15
Truncation in Access / Excel seems to cause me an awful lot of trouble ;( After much challenges to get a union query together that did not truncate my data in a particular field (over 255 charachters long) I am now presented with another unexpected problem.
When I copy the query results from the Access 2007 and paste them into excel the description column is truncated down to 255 charachters even though it is absolutley fine in the database. I have found a quirky way round this iwhich is to paste special as text which solves it however ..
I would have expected to be able to export the data to a .csv, excel2007, or text file without truncation but no such luck - access faithfully truncates anything over 255 charachters .. arggh. Ayone have any ideas to make this a little easier?