does excel truncate at 255?

D

Danny

I have an access database that wil lexport fields larger than 255 to a text
file. THese are memo fields.

IF I import into excel 2002, will the field get truncated?

Thanks
 
D

Debra Dalgleish

In Excel, if you import using MSQuery, the memo fields should import the
text beyond 255 characters.

In Access, use the TransferSpreadsheet method to send the data, and
specify one of the later Excel versions. You can do this by creating a
macro, or writing some code, e.g.:

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

Then, add a button on a form, to run the macro or the code.
 
Top