G Guest Feb 8, 2005 #1 How do get more than 250 characters in a field when exporting data from Access 2000 to an Excel sheet?
How do get more than 250 characters in a field when exporting data from Access 2000 to an Excel sheet?
K Ken Snell [MVP] Feb 8, 2005 #2 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.
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.
