Hi Martin,

IME if you need full control over what goes on in Excel it's best to
automate the Excel object model and address the cells directly, rather
than to treat the worksheet as a table.

That said, how are you creating the worksheet and inserting the field
names? Without having tested it thoroughly I get the impression that if
you create a worksheet, put the field names in the top row and then
execute queries to append the data you'll get the numbers-as-text effect
you're having. But if you create the worksheet with a make-table query
that returns the appropriate field types, subsequent append queries will
append number field values as numbers. This seems to be the case even if
the initial make-table query created a table with zero rows.

Here are the queries I just tried this with:

Make-table query that returns no records:

SELECT ID, FirstName, LastName INTO
 [Excel 8.0;HDR=Yes;Database=C:\Temp\XX.xls;].[Sheet1]
FROM AddrNew WHERE False;

Append query:
INSERT INTO
 [Excel 8.0;HDR=Yes;Database=C:\Temp\XX.xls;].[Sheet1]
SELECT  ID, FirstName, LastName  
 FROM AddrNew;

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.