Sorrry kev i might have bben too brief on the explanation.

The sheet nin the excel needs to have column names in the first row and data in the subsequent rows.

I meant there cannot be five rows of comments explantions or anything above the real data

By default an excel has three sheets in it named Sheet1 Sheet2 and Sheet3.

If they are named differently than the default names you have to use the real sheet name.

when referenced in sql you must add a dollar sign to thenname.

Doing ex sp_tables_ex linkedservername retrieves the names of all sheets.

I think thats the issue with object not found...the sheet has a different name?

So if the sheet was renamed to "Expenses" it would be select * from MyExcelAce...Expenses$