You mean, using Excel.Automation? Sure you can do it this way, but it is time consuming.


>Yuri
>
>I was able to get all the data in the memo fied by importing the data cell by cell.
>
>Mo
>
>>Something like this:
>>

>>store SQLSTRINGCONNECT(;
>>	"DRIVER={Microsoft Excel Driver (*.xls)};" + ;
>>	"FIL=Excel 97;" + ;
>>	"DefaultDir=c:\;" + ;
>>	"DBQ=c:\cim.xls");
>>	TO gnConnHandle
>>	>CURSORSETPROP("FetchMemo",.t.,0)   && set cursor properties in advance
>>
>>*It is important to have " and ' inside select/update statements as  below
>>* field names are inherited from the first row in Excel columns
>>
>>?SQLexec(gnConnHandle, 'select * from "sheet1$"')
>>....
>>
>>

>>
>>>Hello
>>>
>>>is there a way to import data from Excel to a memo column (fvp8) having data more than 254 characters?
>>>
>>>Thanks