I have a query, the results of which are pasted into a spreadsheet template for a monthly KPI report that goes to one of our biggest customers.
The problem is (and I know that this is old news) Access's 255 character limit on fields in a query. Even fields set to longtext or blob get cut off at that 255 character limit.
I need the results of this in a datasheet query in order to paste into Excel and maintain the correct columns. Without anything cut off.
Has anyone figured out a way of getting around this? And if not is there another solution?
The problem is (and I know that this is old news) Access's 255 character limit on fields in a query. Even fields set to longtext or blob get cut off at that 255 character limit.
I need the results of this in a datasheet query in order to paste into Excel and maintain the correct columns. Without anything cut off.
Has anyone figured out a way of getting around this? And if not is there another solution?