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
Amanda Morton
System Analyst
Harrisburg Project