Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with importing excel file into a dbf
Message
 
À
17/09/2004 14:08:58
Eric Gauthier
Transcontinental Interweb (Montreal)
Boucherville, Québec, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00943513
Message ID:
00943543
Vues:
16
Do I take it that you don't know the format and the fieldnames prior to importing the excel sheet or is the format constant that you your create a cursor or a table prior?
Perhaps another option might be to automate Excel and save the file as a DBF.
oExcel = CREATEOBJECT("Excel.application")
owb = oExcel.Workbooks.Open('c:\myExcel.xls')
owb.SaveAs('c:\myTable',7) && DBF format
>hmm, I think i can use this, but this command want a dbf file that already exist. When I import the excel file, a box appear and set a path where the dbf file will be created.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform