TransferSpreadsheet still truncates the memo field

[Deniz]

Hi,

I am trying to export a query result as a comma delimited text file on
Access 2007.

When I use the export wizard, it trims the memo field down to 256
characters. After reading some posts, I decided to use the Macro
action TransferSpreadsheet. However, it didn't change anything - memo
fields are still exported up to 256 characters. When I run the query,
it displays fine on the screen. Am I missing something?

Thanks in advance.

Deniz

 

[Gina Whipp]

Deniz,

Have a look at...

http://www.regina-whipp.com/index_files/MemoFields.htm

....and see if any of the above applies to you.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi,

I am trying to export a query result as a comma delimited text file on
Access 2007.

When I use the export wizard, it trims the memo field down to 256
characters. After reading some posts, I decided to use the Macro
action TransferSpreadsheet. However, it didn't change anything - memo
fields are still exported up to 256 characters. When I run the query,
it displays fine on the screen. Am I missing something?

Thanks in advance.

Deniz