limit on number of characters?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy Ward - 12 Feb 2007 22:17 GMT

I am using Excel 2003, SP2. I just exported the results of an Access query
to Excel and found that the data in one of the fields is being truncated
after 255 characters.

I can type more than 255 characters in a cell. Does anyone know how I can
export more than 255 characters into Excel?

Thank you,
Judy Ward

Reply to this Message

Dave Peterson - 12 Feb 2007 22:45 GMT

I don't speak the Access, but Debra Dalgleish once posted this:

Or, transfer the data with code. Use the TransferSpreadsheet method to
send the data, and specify one of the later Excel versions:

'======================
Sub SendTableToExcel()
DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "tblCustomers", _
"c:\Data\ExcelExport.xls", True
End Sub
'===========================

http://groups.google.co.uk/group/microsoft.public.excel.misc/browse_frm/thread/d
a0bba13524b15d5/81cbe18fd9d6d82b?lnk=st&q=&rnum=4#81cbe18fd9d6d82b

or

http://snipurl.com/1a01v

> I am using Excel 2003, SP2. I just exported the results of an Access query
> to Excel and found that the data in one of the fields is being truncated
[quoted text clipped - 5 lines]
> Thank you,
> Judy Ward

Signature

Dave Peterson

Reply to this Message