INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=YES;Database=C:\pubsTest.xls', 'SELECT * FROM [Sheet1$]')

SELECT * FROM pubs.dbo.authors

Server: Msg 213, Level 16, State 5, Line 1

Insert Error: Column name or number of supplied values does not...

Even this simple query also doesnot work, the issue is still the same... I want the column names to be taken from the select * statement and donot want to...

Thanks for your reply. The thing is this, I donot want to hard code the column names in my excel, so there are NO column names mentioned in the excel....