Importing TXT file into Memo Field

  • Thread starter Thread starter AJOLSON
  • Start date Start date
A

AJOLSON

I want to load the entire content of a txt file into a Memo field. I can't
get around the paragraph markers. Each time I load the file a new record is
created at the end of the paragraph marker, or end of line. In normal cases I
would like that but not this one. Does anyone know what code I could use
that would let me load the entire txt file into one record using one Memo
field?

Here is my current code
DoCmd.TransferText acImport, , "test", "C:\Test\Text.txt", False
 
Thanks,
This got me on the right track. I did a litle twiking to work with my form
and BOOM. Works like a charm.
 
Back
Top