Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Duplicate Field names after EXCEL SaveAs DBF
Message
 
À
21/05/2003 16:08:11
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00791309
Message ID:
00791317
Vues:
28
It will not allow you to modify the structure in foxpro.
Consider foxpro import command instead.

>Hello all, here is my problem. I am saving an excel spreadsheet as a DBF using OLE Automation, here is my code:
>
>oExcel.activeworkbook.saveas(lcDBFFile,xlDBF3)
>oExcel.activeworkbook.Saved = .t.
>oExcel.quit()
>

>The problem is, the Excel spreadsheet has two columns that are named the same thing. When it saves it as a DBF, it is keeping the duplicate columns, which creates duplicate field names. WTF? Isn't this strictly illegal? How can I prevent this type of behavior?
>TIA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform