Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import from excel
Message
De
15/02/2008 09:42:50
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
01292874
Message ID:
01292952
Vues:
25
>hi all
>I am trying to import from an excel file into a cursor that i have created. I use the following
>
>mremitfile = GETFILE('xls',' ','OK',0,'Select the file')
>...
>APPEND FROM (mremitfile) TYPE XLS
>
>and that works fine once the file is in 97-2003 format. the kicker is that i export this file from another location using OLE and it saves as an xls file, but if i try to import this file without saving as 97-2003 i get an error saying that the file type is not a valid xls. i would like to be able to import the file without getting the user to save as first
>~M

Mark,
ADO is the way:)
Check http://www.foxite.com/archives/vista-excel-compatibility-w-worksheets-0000153776.htm
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform