TransferSpreadsheet still truncates the memo field


D

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top