Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    1

    Unanswered: Import data from excel file to Mircosoft SQL Server

    Can anyone guide me how to import data from excel file to Microsoft SQL Server? My excel file just have the data, no column name.

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Use DTS ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by Enigma
    Use DTS ???
    Use DTS !!!

    -- This is all just a Figment of my Imagination --

  4. #4
    Join Date
    Jan 2003
    Location
    Pittsburgh, PA
    Posts
    86

    Data Transformation Services

    Use SQL's Data Transformation Services. You can use the Import Wizard, which will walk you through finding your EXCEL file and importing it into an existing / new table in the database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •