Results 1 to 2 of 2

Thread: Excel to MSSQL

  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Unanswered: Excel to MSSQL

    hi

    i have an excel sheet with 2 columns
    regno name
    ----- ------
    and a table regdetails of the form

    regdetails
    (
    regno bigint
    name varchar(30)
    )

    my requirement is to export the data from excel sheet to the table.
    the excel sheet may have duplicate entries but i want only distinct
    records to be exported to the table.

    can i create a DTS package to perform this ?

    please post ur comments
    Cheers....

    baburajv

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Yes you can accomplish this with DTS, import to a temp table and delete duplicate rows then copy to original table. May check http://www.sqldts.com website for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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