Lidou123 (1/10/2013)
Hi All,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
, of course).
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.