Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

can u please help me guys Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 7:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 15, 2011 12:48 AM
Points: 5, Visits: 11
guys 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! :D
Post #1063959
Posted Thursday, March 10, 2011 8:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, June 26, 2014 8:49 AM
Points: 2,276, Visits: 779
there are many ways you can do this

i often opt to save the Excel file as CSV and then use BULK INSERT
you could use SSIS packages

but 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 table


MVDBA
Post #1076299
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse