Exporting Memo Fields containing over 255 Characters to Excel

[okitamura]

Hi,

I have recently solved one of my problems of not being able to extract data containing over 255 Characters from Access Query. This was done by appending the query results to a table that has Momo fields to accomodate the long text field. Now I want to export this table with Memo fields to Excel Spreadsheet. Currently the momo field data is truncated at 255th character upon exporting to Excel spreadsheet. I have Office 2000 so both Access and Excel is 2000. After all, the question is simple: Is there a way to Export an access table containing Memo fields to Excel Spraedsheet without any truncation?

 

[dawnd3]

Hi there, I just tried it out, just to be sure, and it worked for me. (I have 2003 though.) But here is what I was thinking...maybe it is not truncated but wrapped in the field. You can either widen (size to fit) the row to see if it is indeed all there or uncheck the wrap text option in the format cells dialog box, under the alignment tab.

Let me know what you find out.

Dawn

http://www.calliopeconsulting.net

 

[jrshaw03]

Replace all of your UNION fields with UNION ALL. This may give you other problems later on, but it should get you down the road.

Jimmy

 

[dawnd3]

Jimmy, are you sure you posted in the right place? Unless I am missing something, your answer doesn't seem to match this post.

Take Care,


Dawn

http://www.calliopeconsulting.net