limit on number of characters?

G

Guest

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
 
D

Dave Peterson

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/mi...18fd9d6d82b?lnk=st&q=&rnum=4#81cbe18fd9d6d82b

or

http://snipurl.com/1a01v
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top