Post reply

export and import data

  • August 6, 2009 at 10:51 pm

    #213251

    i want to export data from sql server 2005 to microsoft excel 2007/2003 and similarly import data from ms excel to sql server2005

  • August 7, 2009 at 6:50 am

    #1035946

    you can use the import/export wizard in SSMS. Right click database, goto Tasks, then Import (or export) Data

  • August 8, 2009 at 4:34 pm

    #1036441

    With SSIS is it very easy to read/write data to/from Excel.

    So i would have a llok at that

    /mSc

    http://www.performanceduo.com

  • August 10, 2009 at 2:34 am

    #1036628

    Hi

    If you need to this frequently you can implement this using SSIS. If you do this on rare occasions then just use the import/export wizard.

    "Keep Trying"

  • August 10, 2009 at 8:59 pm

    #1037200

    If you have installed SQL server on the default directory look for the dts import/export wizard at C:\Program Files\Microsoft SQL Server\90\DTS\Binn folder.

    As said by previous answerers , use the dts import/export wizard for one time data movement and SSIS packages for a regularisied data import and export.

    Hope this helps!

    Leks

Viewing 5 posts - 1 through 4 (of 4 total)

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