>>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
>
>As I thought this one was weird. I know you probably experienced doing SELECT statement and getting a truncated text back because the first row has a short data in it.
>Well, this one is the same category. The memo column in excel first row is NULL so the above code gave me back 256 characer for the memo. When I changed the data in the first row I got the right data back.
Interesting....
If it's not broken, fix it until it is.
My Blog