Export to Excel. Text missing in some cells.

[debo]

Hi. I am trying to undertake what should be the simple process of exporting an Access file to Excel.

This is working fine but when I open the file in Excel, some of the text from the original fields in Access is not present in the corresponding Excel cell.

There isn't masses of text. Approximately 70 words per field.

Thanks and apologies if this is ignorant as I am just starting out with Access.

 

[mcadle]

It could be, don't hold me to this, but Access and Excel both have a 255 character limit (for a text field in Access and per cell in Excel.) I have analyzed files in excel with no issues, as long as I used analyze(tools - office tools - analyze). When exporting I have had a few issues. Hope this helps

 

[ghudson]

The TransferSpreadsheet method will let you export data from Access that has more than 255 characters into Excel.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "YourTable", "C:\Test.xls", True

 

[debo]

thanks for your replies. Unfortunately, I am not very experienced with any of this and the above commands read like a foreign language to me. Is this a macro command? I am trying to use the transferspreadsheet action but am not sure what to put in each of the object commands.

thanks again

 

[mcadle]

You can create a command button (click cancel when the wizard starts) then in its properties -- on click -- put the code that GHudson stated. That way, when ever the end user clicks on that command button, it does the transfer. Hope this helps.