I wonder if anyone can help with an exporting problem from MS Access 2003 to Excel 2003.
Basically the attached code creates an Excel spreadsheet and launches a template file (Word Template) that opens the exported spreadsheet, and runs a mail merge etc. The export item 'Qry_MM_Export' is a query.
The process works, however there is one column that exceeds 255 characters, and when it exports it to the spreadsheet, it seems to truncate the data. But when you look at the query itself, the data is all there.
Please could someone help me export all the data to the spreadsheet without it truncating.
(By the way, the truncated column is not a field from a table, it is text that comes in from a function)
Thanks VERY much in advance
'//Now export the data and shell the file.
ExportFile = "C:\MailMergeExport.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qry_MM_Export", ExportFile, True
a = ShellApp(TemplateFile, vbMaximizedFocus)