>I have two tables, detail.dbf and summary.dbf.
>
>I want to be able to save to an XLS file with two sheets, one for the detail and one for the summary. What is the best way to do this?
Create a workbook via automation and add 2 tables into 2 sheets using QueryTables.Add() method. Check
Re: COPY TO command cutting out MEMO Fields Thread #
1079707 Message #
1080043Cetin