Post reply

Importing/Exporting spreadsheet and text file data into SQL 2005

  • February 18, 2009 at 12:36 pm

    #134831

    With SQL 2000, I could right click on a table and select Import Data in order to import/export data in a spreadsheet or text file. How may I do this in SQL 2005? Someone told me I would have to use Integration Services. What are the basic beginning steps to import a text file into a table.

    Thanks in advance, Kevin

  • February 18, 2009 at 6:33 pm

    #946435

    There is an Import/Export Wizard which uses SSIS, instead of DTS.

    Just right-click your db in SSMS and select Tasks / Import (or Export) data.

    That should get you started.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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