Importing TXT file into Memo Field

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
 
A

AJOLSON

Thanks,
This got me on the right track. I did a litle twiking to work with my form
and BOOM. Works like a charm.
 

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

Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Import multiple text file into memo field table 3
Importing Excel Data Into MS Access Memo Field 2
Importing txt file 7
problems importing a Paradox file into Access 2003 4
memo fields output to text file 1
Import txt file - records on multiple lines 1
Export Memo to txt - truncates at 255 1

Top