Exporting five Paradox tables to Excel using a Form button. Need Code

[rakster]

I trying to export five paradox tables to Excel using a form button.<br><br>The idea is automating the exporting process as this is done every week. <br><br>I need the code for the Pushbutton on the form and some general form building advice to how to create this form.<br><br>Your help is appreciated.<br><br>RAKSTER

 

[dglidden]

Use the &quot;exportspreadsheet&quot; command.<br><br>example:&nbsp;&nbsp;exportspreadsheet(&quot;:aliasname:tablename.db&quot;,&quot;c:\\temp\\myfile.xls&quot;,true)<br><br>This will export the table (&quot;tablename&quot to an excell table (&quot;myfile&quot in the c:\temp directory.

 

[buttersoft]

This tip can also be found in the on-line help, it also exports nicely into Quattro Pro V9.<br><br>One think I noticed in both Quattro Pro and Excel, is that columns with DATES, display as a number. Reformatting the columns to display as a Date, cured that with no problems.