Information générale
Catégorie:
COM/DCOM et OLE Automation
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement