Exporting data from Access 2000 to Excel sheet

R

Rizla

How do get more than 250 characters in a field when exporting data from
Access 2000 to an Excel sheet?
 
K

Ken Snell [MVP]

Use a macro with the TransferSpreadsheet, or use VBA code to run the
DoCmd.TransferSpreadsheet method. The manual method (File | Export) uses the
EXCEL 95 format, which limited strings to 255 characters.
 
Top