<div>
James, if you were satisfied with the answer then please close the question. If not then don't hesitate to ask for more details.<br />
<br />
P.C.
</div>


James, if you were satisfied with the answer then please close the question. If not then don't hesitate to ask for more details.

P.C.

<div>
Two solutions were provided. Excel automation is suitable for simple sheets, COPY TO command can export thousands of lines.
</div>


Two solutions were provided. Excel automation is suitable for simple sheets, COPY TO command can export thousands of lines.

<div>
<div class="content wysiwyg-content">
I need a way to export data to excel but to be able to create multiple tables (tabs) in the excel file. &nbsp;How can this be done?
</div>
</div>


I need a way to export data to excel but to be able to create multiple tables (tabs) in the excel file.  How can this be done?

Visual Foxpro export to tabulated excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

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.

FoxPro

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.