Inserting content of TXT fiel into Memo field 1

[foxrainer]

I know this must be simeple, but I can't get it to work:

I have a file (ROS.txt) with general text type info

When inserting a record into one of my tables (using INSERT INTO SQL), I would also like to have the content of ROS.txt inserted into a memof field called ROS. What is the simplest way?

Thank you in advance

Rainer

 

[jimoo]

lcMyFile = FILETOSTR("c:\MytextFile.txt")
REPLACE myMemoField WITH lcMyfile

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[foxrainer]

Jim,

thank you tons! I didn't know this function exists,

Rainer

 

[jimoo]

Another function that is handy in this instance is ALINES().

It brings the data into an array. Sometimes this is better because you can parse out unwanted text prior to writing it the memo field.

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[foxrainer]

Jim,

good advice as well - I actually have another use for ALINES() now that I looked it up!

Thank you

Rainer