Post reply

can u please help me guys

  • February 14, 2011 at 7:25 pm

    #245473

    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! 😀

  • March 10, 2011 at 8:37 am

    #1297135

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply