Export Problem

[TomT]

I'm trying to export a table to a tab seperated value file. I can do this
through the access wizard but have 1 problem. The memo fields get truncated
to 255 chars. Is there any other way I can accomplish this without the
truncation?
I'm using Access2003

Thanks,

TomT

 

[Jeanette Cunningham]

Tom,
I tried this but I didn't get any truncation of the memo field. My memo
field had 665 characters and it exported with all the characters as a tab
delimited txt file.
The memo field was in a table. If you try to export a query with a
calculated field with more than 255 characters you will see truncation.
Usually a table memo field exports fine. I used A2003 SP3 + hotfix, and I
know it works with A2003 SP2.

I'm not sure why you say this problem.


Jeanette Cunningham -- Melbourne Victoria Australia