InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:21:16 GMT20http://www.sqlservercentral.com/Forums/Topic1063959-2838-1.aspxthere are many ways you can do thisi often opt to save the Excel file as CSV and then use BULK INSERT you could use SSIS packagesbut by far the easiest way for Ad-Hoc inserts is to make the excel spreadsheet have the same column structure as your table and then cut and paste straight into your tableThu, 10 Mar 2011 08:37:56 GMTMVDBAhttp://www.sqlservercentral.com/Forums/Topic1063959-2838-1.aspxguys do you know how to import data from excel 2010 to MS Sql 9.0? Should that need an SSIS or some DTS?help me please.. thanks! :DMon, 14 Feb 2011 19:25:22 GMTa.campos132