Check Re: Copy To Type XL5 - limit on number of records? Thread #1379610 Message #1379634

>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