V
Virginia Kirkendall
I've read that DoCmd.OutPutTo defaults to Excel 95/97 (WHY?) which
only allows for 255 chr in text formatted fields. I understand why
then that DoCmd.OutputTo with excel specified as the format will
produce this truncate "feature." So, why then do I get the same
truncated text when I take out the file type from outputto? The OutPut
To file type selections appear I choose Excel 2002 and get the same
results.
Of course, transferspreadsheet does not truncate the memo fields, but
I am interested in outputting reports to save the grouping levels in
Excel as well.
Does anyone have any idea why this happens? Thanks very much, Ginger
only allows for 255 chr in text formatted fields. I understand why
then that DoCmd.OutputTo with excel specified as the format will
produce this truncate "feature." So, why then do I get the same
truncated text when I take out the file type from outputto? The OutPut
To file type selections appear I choose Excel 2002 and get the same
results.
Of course, transferspreadsheet does not truncate the memo fields, but
I am interested in outputting reports to save the grouping levels in
Excel as well.
Does anyone have any idea why this happens? Thanks very much, Ginger