SQL Server Performance Forum – Threads Archive

Import

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
SQL-Server-Performance.com 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 www.sqlservercentral.com/columnists/JTallamraju/data_import_functionality_using.asp —————————————-
http://spaces.msn.com/members/dineshasanka

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

]]>