For years I have been using the following code to import excel data to VFP memo. it was works fine.
I using Excel 2002


store SQLSTRINGCONNECT(;
"DRIVER={Microsoft Excel Driver (*.xls)};" + ;
"FIL=Excel 97;" + ;
"DefaultDir=c:\;" + ;
"DBQ=c:\name.xls");
TO gnConnHandle

CURSORSETPROP("FetchMemo",.t.,0)

?SQLExec(gnConnHandle, 'select * from "Sheet1$"')


Today I did an export it only copied 256 characters from Excel to the memo field. I am so lost I have no clue why
it stops copying the whole data in the excel cell.

Help