Insert data from Excel to SQL Server 2005 by using copy and paste commands

(Kun Lee) Loading data from SQL Server to Excel is a common practice in many automated and ad-hoc processes completed by DBAs on a daily basis. Traditionally loading data from Excel to SQL Server has been completed by DTS, SSIS, BCP, OPENROWSET, ImportExport Wizard, etc. Unfortunately, for a simp

Read More - Register for Free Membership