Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Import/Append with Memo
Message
De
18/11/2008 11:28:18
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Excel Import/Append with Memo
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:
01362569
Vues:
64
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!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform