/* Test.prg Open a dbf table with Excel 2007. This code is a basic sample. With Excel 2007, i can not save to dbf. I do not know if it works with Office 365. */ DROP TABLE "_Result3" DROP TABLE "_Result7" CREATE TABLE "_Result7" (; SALESID CHAR(6), ; CUSTOMERID CHAR(10), ; ORDERDATE DATE, ; ORDERNMBR NUMERIC(7,0), ; ORDERAMT NUMERIC(9,2), ; DELIVERED BOOLEAN) //sele 1 use _Result7.dbf append blank replace SALESID with "A25" replace CUSTOMERID with "Allan" replace ORDERDATE with date() replace ORDERNMBR with 1258 replace ORDERAMT with 25.78 replace DELIVERED with false appe blank replace DELIVERED with true // Look null fields. copy to _Result3.dbf dbmemo3 use oExcel = new OleAutoClient( "Excel.Application" ) oBook = oExcel.WorkBooks.open( set( "directory" ) + "\_Result3.dbf" ) oExcel.Visible = true return