Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Import/Append with Memo
Message
 
 
À
18/11/2008 11:28:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01362569
Message ID:
01362589
Vues:
21
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform