Maximum of the Excel cell.

[Frank]

Hi,

When I export a report from Access to Excel and I have a
remarks field that contains a lot of characters (300 and
more) they won't show up in the Excel sheet.

Can this be changed in Excell easily with a setting or
anything. I know that cells only can contain 255 ch. or
less.

thanx.

Frank

 

[Andy Brown]

Frank,

My XL (2K) Help says -

Maximum Column width 255 characters
Length of cell contents (text)32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

Have you tried formatting the cell(s) to Wrap Text?

HTH,
Andy

 

[Debra Dalgleish]

If the data doesn't all arrive in Excel (you can't see it in the formula
bar or the cell), and you're using code, specify that you want to use
Excel 97 (Excel8) or later:

Sub SentToExcel()
DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel8, "tblCustomers", _
"c:\data\Customer.xls"
End Sub

If you're choosing File>Save As/Export, select Microsoft Excel(*.xls)
for the file type.

 

[AITOR]

With Excel 2002/XP the limits are 1.204 characters shown
on a cell from the 32627 characters stored internally and
shown in the editing window.