For an existing Excel table e.g. worksheet:

 INSERT INTO
   [Excel 8.0;database=C:\MyWorkbook.xls;].[MyWorksheet$]
 (MyCol1, MyCol2, MyCol3)
 SELECT
   ColA AS MyCol1,
   ColB AS MyCol2,
   ColC AS MyCol3
 FROM
   MyTable
 ;

To create a new Excel workbook/worksheet/table:

 SELECT
   ColA AS MyCol1,
   ColB AS MyCol2,
   ColC AS MyCol3
 INTO
   [Excel 8.0;Database=C:\NewWorkbook.xls;].MyBookLevelName
 FROM
   MyTable
 ;

To create a new table, the defined Name (named Range) must not already
exist. Therefore, first issue a DROP TABLE e.g.

 DROP TABLE
   [Excel 8.0;Database=C:\NewWorkbook.xls;].MyBookLevelName
 ;

Jamie.

--