ACCESS to EXCEL problems
 

I’m using a ‘Transfer spreadsheet’ action in Access to export the
results of a cross tab query into an EXCEL spreadsheet. Some of the
Column headings of the cross tab query are more than 64 characters long
and when these are transferred to the excel sheet they are truncated to
64 charaters and some of the heading is lost. It is not possible to
abbreviate any field names.

Does anyone know if the problem is likely to be in ACCESS or EXCEL?


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=536847