I think I found the solution: http://www.sqlservercentral.com/Forums/Topic1232909-2674-1.aspx
But I don't know if it works with excel file?
What do U think ?
It won't work with Excel files without tweaking the code, that's for sure. But it's probably do-able.
How many rows do the spreadsheets typically contain? If more than a few thousand, this technique is likely to be slow.
What happens to the data once it has been imported? As the table is going to be dropped and recreated tomorrow, it has only a one-day lifespan - and as the column names are changing all the time, a new query will need to be written every day to use it (except for SELECT * FROM [table], of course).
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.