>Hi,
>
>After opening the excel spredsheet with "oWorkbook=Getobject('c:\my documents\sample.xls')". Then, I am trying to save the file as DBF with "oWorkbook.SaveAs('c:\mydocuments\sample.dbf',...)" but I am not successful. I am referencing the book "Microsoft Office Automation with Visual FoxPro", and it describes, I need to use the file format as an optional second parameter with command "...SaveAs...". I tried many different possible ways for the second parameter, but none had worked.
>
>Thank you in advance.
>
>Kay
#define xlDBF3 8
oWorkbook.SaveAs('c:\mydocuments\sample.dbf',xlDBF3)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.