Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
EXCEL to DBF - MODIFY - return to EXCEL
Message
De
30/06/2003 16:19:58
 
 
À
30/06/2003 15:58:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00805454
Message ID:
00805466
Vues:
32
This message has been marked as a message which has helped to the initial question of the thread.
Hi Kevin,

You can do this in VFP.
create cursor test (f1 i, f2 i)
insert into test values (1,1)
insert into test values (2,2)
insert into test values (3,3)

copy to c:\testnew xl5
copy structure to c:\testnew
use c:\testnew

suspend && open in excel, change, resume
* IMPORTANT!!! 
* - Remove the column headers (ie F1,F2)
* - Dont do anything that will modify the structure (ie. move columns around)

append from c:\testnew xl5 
HTH.

>The last part, the modify and to copy a table to type xls format is easy, but is there any easy way to open an excel file as a formated table in VFP so that I can modify, add columns, etc. then return the results to excel. The only part I would need to know is how to open an excel file up as a table in VFP or somehow copy it in a way to convert it that I can open it.
ramil
~~ learning to stand still
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform