Import to Memo Field?

[gregjohn]

I have an adobe form that I am exporting to a txt file and then saving as an excel worksheet. The adobe form allows the user to a comment section in which they can clarify some answers. As long as the answers are less than 255 characters, everything gets imported ok. However, that is not always going to be the case.

I have changed my foxpro table to accept memo fields. However, when I issue an append from the fields with characters more than 255 come in as null. Any ideas on what I am doing incorrectly?

Thanks

 

[JimWWinter]

I assume you're trying to append from the excel file into your table. That won't work with more than 254 characters in the field even though the table field is a memo.

The only way I've found to deal with this situation is to use excel automation and replace commands. For example, if you have an excel file called BigMemo with potentially larger than 254 characters in the A column and you have a dbf called TestMemo, you might do something like this. Not tested.

USE TestMemo
oX = CREATEOBJECT('Excel.Application')
oX.Workbooks.Open('BigMemo.xls')
oR = oX.Range('A1')
nCtr = 1
DO WHILE LEN(TRIM(oR.OffSet(nCtr).Value)) > 0
   REPLACE TestMemo.MyMemo WITH oR.OffSet(nCtr).Value
   nCtr = nCtr + 1
ENDDO

Regards,
Jim

 

[baltman]

You might want to try importing directly from the text files or programatically grabing the data directly out of the PDF. Either would be more robust and faster since you'd be skiping Excel.

Brian

 

[gtc1700]

I have this problem also. I Have a web form that posts to a text file. Some of the fields are longer than 254. If I use a character field in my VFP table, an append command splits the long fields and excess goes into the next field. If I use a memo field, append command does not get the data into the memo field. Will I have to parse the long fields into separate text files and use Append Memo? or parse to an array?

Is there any trick that doesn't require parsing the text file?

 

[baltman]

Two columns of 254 next to each other and a memo field at the end of the table...

Create MyTable (Fields...)
Append from MyFile.txt type sdf
Replace MyMemoFld with CharFld1+CharFld2
Alter Table DBF() Drop Column CharFld1 Drop Column CharFld2