transfertext and Memo fields

P

Pete Halasovski

Hi,

I'm trying to export data to a CSV file using Transfertext in a macro. My
problem is that one of the fields to be exported is a Memo field and Access
truncates this data at 255 characters. Does anyone know of a good work
around for this problem?

Regards,

Pete
 
L

Les

Pete,
I think I had this problem when I tried to export from
a query. I created a table, changed my query to append
into the table, then I was able to export the memo field.

HTH
 
E

Ed Robichaud

I think your only hope is to parse the memo field into separete 255 char
text fields before exporting. See Access VB Help for InStr functions.
-Ed
 
J

John Nurick

Hi Pete,

Normally memo fields export to CSV files without problems (provided they
don't hit the 65,000 character limit on the exported record). But if
they have been formatted (e.g. with the Format() function or a Format
property) or are assembled from a VBA expression, the result is treated
as a text field and truncated at 255 characters.
 

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