xlDBF3 is a constant which - initially - Excel understands, but VFP not. The relevant Excel constants are defined in download #1005. Please get it! That's what I have the #INCLUDE command for.

Hilmar.

>Thanks for the assistance with all this stuff. Unfortunately, it does not seem to be taking to Office XP too well. It cannot find the variable xlDBF3.I am assuming that is what it is supposed to convert it to.
>
>>Download #9498 contains Excel constants. You need it for the following program.
>>
>>The result will be exactly the same as if you export manually from Excel. For best results, the spreadsheet should have a first row with column (field) names.
>>
>>

>>#include include\xl97cons.h
>>oExcel = CreateObject("Excel.Application")
>>oExcel.Visible = 1   && for debugging
>>oExcel.Workbooks.Open(fullpath("") + "sample.xls")
>>erase sample.dbf
>>oExcel.ActiveWorkbook.SaveAs(fullpath("") + "sample.dbf", xlDBF3)
>>oExcel.Activeworkbook.Close(0)
>>

>>
>>See also: SET CPDIALOG.
>>
>>HTH, Hilmar.
>>
>>>I attempted to export directly from Excel, but it cut off a lot of the data. i looked up the automation, but I do not understand it's process. I am attemping to create the table first and append from, but it will not let me append from an xls file.