>Hey all!
>
>I have an Excel file that I can get into a standalone table with this:
>
>
>IMPORT from "E:\src\sampleproducts_20081113.xls" TYPE XLS
>
>
>One column in the resulting table, when a row value is > 255 characters, comes through empty.
>
>So I then tried this:
>
>
>ZAP
>MODIFY STRUCTURE (changed the problem column from "char" to "memo)
>APPEND FROM "E:\src\sampleproducts_20081113.xls" TYPE XLS
>BROWSE last
>
>
>And some row values that that column are still empty, although they are now Memo column/field type.
>
>Opening the file in Excel 2007 shows all of the data fine, but of course I need to do this with VFP.
>
>All suggestions appreciated.
>
>Thanks!
See
Re: Memo field to excel Thread #
1219676 Message #
1219738 and the whole thread.
If it's not broken, fix it until it is.
My Blog