By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Exporting the maximum characters.

P: n/a
I have a column name [Description] the Data type is MEMO
The input is more than thousands of characters.

When exporting, not all the information is exported.
Who can I correct this problem?
Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
my*****@hotmail.com (Jacky11) wrote in message news:<46**************************@posting.google. com>...
I have a column name [Description] the Data type is MEMO
The input is more than thousands of characters.

When exporting, not all the information is exported.
Who can I correct this problem?
Thanks

what filetype are you exporting to ?
and if text, delimited or fixed ?

when exporting to fixed size, check the columnwidth before finishing
using the advanced button. Memo-fields become 512 default, but you can
change that to whatever you like. Other filetypes could have some
maximum fieldsize or have the same default-size defined for exported
memo-fields.
The reason of this is probably because theoretically a memo-field
could be 2 Gb in size.
When automating the export through a macro (TransferText), store the
correct export-definition by name in the advanced screen and refer to
that name in the macro.

Marc
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.