Import | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


How can I import an excel sheet into my sql table? Here columns in the Excel sheet and my sql table are same. Thanks!
"He laughs best who laughs last"
You can use DTS to do that.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
DTS is the best and easiest way of doing it. If you are reluctant to use DTS you can use ADO also —————————————-

Thanks guys. Thanks!
"He laughs best who laughs last"