As I wrote in my earlier message, it seems that Excel2007 can not save as dbf. May I ask why you won't use APPEND FROM or IMPORT?
>Hi,
>I use SAVE AS to change the excel file into DBF file,
>but it have error at SaveAs statement.
>
>What's wrong ?
>
>
>
>vfile= "W110120.XLS"
>oExcel = CreateObject("Excel.Application")
>oWorkbook = oExcel.Workbooks.Open(vFile)
>tSheets = oWorkbook.Sheets.Count
>oExcel.Workbooks.SaveAs("W110120.DBF",8)
>
>
>
>Please advise.
>Thanks.
>Derek