Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Import/Append with Memo
Message
 
 
To
18/11/2008 11:28:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01362569
Message ID:
01362589
Views:
22
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform