CopyFromRecordset, not exporting all data for a memo field.

  • Thread starter Kevin McCartney
  • Start date
K

Kevin McCartney

Hi TWIMC,

I'm using the following command to export data from an Access database using
a DAO recordset,

wsData.Range("A2").CopyFromRecordset rst

Everything works great except for one field, which is a memo field, yes
you've guessed it, not all of the contents fo the memo field are exported to
the cell. So the question is, why does this happen and has anyone come up
with a solution, or is the only solution to check each field data type and
for each field that has a data type of MEMO, export this field record by
record.

TIA
KM
 

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

Restoring line breaks in memo field 2
VBA - exporting serial letters to single documents 0
Exporting data from table with memo field 0
Memo field 3
Using Findfirst recordset to search memo field type 11
memo field weirdness 0
Popup a Memo field to add more data 5
Write to a Memo Field 1

Top