SQL Server Performance

Importing data

Discussion in 'SQL Server 2005 General Developer Questions' started by myoungbl, Nov 15, 2005.

  1. myoungbl New Member

    SQL 2000 had a import/export wizard. What doe SQL 2005 have to do this work? I simply want to be able to import data from an excel spreadsheet, and be able to select which columns I wish to import. The How-To I found referenced using a SQL ServerBusiness Development Studio project for importing, but I could not find the reference. I don't have the exact name of the project mentioned, but it was not available in my list of projects.

    Can someone shed any light on how to do this?

    Thanks.

    Marshall

  2. derrickleggett New Member

    You can still import/export data in SQL Server 2005. Right-click on a database in the SQL Server Management Studio and choose import. You can then choose Excel, OLE source, etc. You can also save the import as an SSIS package, just like you could save a DTS package.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. mulhall New Member

    Commandline:

    dtswizard
  4. Madhivanan Moderator

  5. myoungbl New Member

    Thanks, D.

    I found the import feature. I was right-clicking on the database itself, instead of the database group. It was found there.

    Marshall C Youngblood
  6. myoungbl New Member

    Another question on this topic. I want to create a unique identifier for each record I import, but that field does not exist in the spreadsheet. How can I force the import wiz to create and populate that field, and then to populate during subsequent imports? I tried modifying the SQL statement that creats the table by adding the line [ItemID] uniqueidenifier, but the import failed.

    Thanks.

    Marshall
  7. mulhall New Member

    Do the import first, then add the uniqueIDs.
  8. satya Moderator

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=5911 for further reference.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page