<div>
As Captain said second parameter is constant for FileFormat.<br />
<br />
To supress excel dipslaying dialog for save :<br />
&nbsp;<br />
#DEFINE xlDBF4 11<br />
appexcel=createobject('Exc<wbr />el.Applica<wbr />tion')<br />
with appexcel<br />
&nbsp; .DisplayAlerts = .F.<br />
&nbsp; .workbooks.open(&quot;c:\test\t<wbr />est.xls&quot;)<br />
&nbsp; .activeworkbook.saveas(&quot;c:<wbr />\test\test<wbr />.dbf&quot;,xlDB<wbr />F4)<br />
&nbsp; .activeworkbook.saved = .t.<br />
* .Quit<br />
endwith 
</div>


As Captain said second parameter is constant for FileFormat.

To supress excel dipslaying dialog for save :
 
#DEFINE xlDBF4 11
appexcel=createobject('Excel.Application')
with appexcel
  .DisplayAlerts = .F.
  .workbooks.open("c:\test\test.xls")
  .activeworkbook.saveas("c:\test\test.dbf",xlDBF4)
  .activeworkbook.saved = .t.
* .Quit
endwith

<div>
you can also create the cursor in foxpro and append from the excel file and copy to a dbf<br />
<br />
CREATE CURSOR ...<br />
APPEND FROM xlsfile TYPE XLS FIELDS field1, field2, field3, ...<br />
COPY TO ...
</div>


you can also create the cursor in foxpro and append from the excel file and copy to a dbf

CREATE CURSOR ...
APPEND FROM xlsfile TYPE XLS FIELDS field1, field2, field3, ...
COPY TO ...

<div>
<div class="content wysiwyg-content">
Please check out a portion of my vfp code regarding excel application in vfp.<br />
<br />
appexcel=createobject('Exc<wbr />el.Applica<wbr />tion')<br />
with appexcel<br />
&nbsp; &nbsp;.workbooks.open(&quot;c:\test\t<wbr />est.xls&quot;)<br />
&nbsp; &nbsp;.activeworkbook.saveas(&quot;c:<wbr />\test\test<wbr />.dbf,&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot;dbf4)<br />
endwith<br />
<br />
My intention is to save the excel file(.xls) in database format. But when I tried to run the program, I'm not getting the right result. Kindly help me on this matter.
</div>
</div>


Please check out a portion of my vfp code regarding excel application in vfp.

appexcel=createobject('Excel.Application')
with appexcel
   .workbooks.open("c:\test\test.xls")
   .activeworkbook.saveas("c:\test\test.dbf,";
           "dbf4)
endwith

My intention is to save the excel file(.xls) in database format. But when I tried to run the program, I'm not getting the right result. Kindly help me on this matter.

Excel Application in VFP

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.