Output to Excel from Access - character limit of 255 causing problems!
Posted on 2003-03-14
I have an Access database which I am running through XP. On the click event a query is run which outputs the selected company's details (approx99lines) to an excel file. Have had no problem with this in the past, until now. One of the fields is a memo field so that we can get more than 255 characters in this field. When this is outputted to Excel the "comments" field, set as a memo field, has been reset to 255 characters in Excel. I have explored why this is and have found out that Excel is set to a field default of 255 characcters. I have therefore changed the default column width to increase the character length. This was then saved as an excel template in the ExcelStart folder so that when a new sheet is selected it is the default setting over 255. Unfortunatly when the outputto function is performed the "commewnts" field is still cut down to 255 characters. The excel file is needed so that the details can be sent by email to other members and loaded into their database into a table. Any ideas on how to get past this? Alternatives?
Look forward to replies, help I'm loosing my hair!