Lowell - that was part of it. The sheets in question were named 'table'. So I fixed that.

What I've got now is basically:

INSERT INTO dbo.existingTable(ColumnName1, ColumnName2, ColumnName3)

SELECT * FROM MyExcelACE...table$

When I try to execute the query I get the following:

Msg 7202, Level 11, State 2, Line 35

Could not find server 'MyExcelACE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

Any thoughts?