Importing/Exporting spreadsheet and text file data into SQL 2005

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  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

  ---