MartinnitraM


Hi

I'm trying to import data from an Excel spreadsheet into a Foxpro v8 memo field using the APPEND FROM command something like this, but the field is blank after I run the append.

CREATE TABLE "C:\Blah\TESTMEMO.DBF" NAME "TESTMEMO" (TESTMEMO M NOT NULL)
APPEND FROM "C:\Blah\TESTMEMO.xls" TYPE XL8 SHEET "SHEET1"

Any ideas how I can do this

Thanks




Re: Importing data from Excel into a FoxPro Memo field

dni


I am not sure, but I don't think is working.May be if you import xls file first in a table and after that to try to format a vector with data to put it in a memo field...







Re: Importing data from Excel into a FoxPro Memo field


Re: Importing data from Excel into a FoxPro Memo field

MartinnitraM

Many thanks for pointing me in the right direction.





Re: Importing data from Excel into a FoxPro Memo field

Naomi Nosonovsky

You're welcome.