Export a memo field

  • Thread starter Thread starter Netalie
  • Start date Start date
N

Netalie

Hi,
i have a problem while i export a table with a memo data
type field. access converts it to a text field and by
that cut's off the string.

How can i export it currectly?

Thanks
 
Exporting to what type of file? EXCEL? Text? How are you doing the export?

More details, please.
 
Hi, i'm exporting to a delimited text file, using the
exoprt procedure in access.

DoCmd.TransferText acExportDelim, "C Export
Specification", "temp_tbl", TmpFileName, False, ""
 
Are you exporting it as unformatted? That works for me in a test I just set
up.
 
You must log in or register to reply here.

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

Similar Threads

Create Temp table from query, with memo fields? 7
Running Query on memo field - character limit 4
How to Convert EML to PST? 2
Memo fields truncated by TransferText 2
Memo field Truncation 2
Memo Field cut off in query 4
Data Type Issue in Linked Excel Table 7
Access 2003 export to excel - truncated memo fields 1

Back
Top