Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unanswered: Bulk Insert Utility

    I need to import data from an excel file to a SQL SERVER databse with the help of BUlk insert utility (with out running a DTS).Can anybody tell me the code?I need to place the code in a Stored Procedure.

    Subhasish

  2. #2
    Join Date
    Oct 2003
    Location
    Montevideo, Uruguay, South America
    Posts
    13

    Re: Bulk Insert Utility

    Hi!

    Bulk Insert task is a kind of task that can be included into a DTS package.
    I believe you CAN´T import from an excel file using an stored procedure, you have to create a DTS package

    see ya
    Lorena




    Originally posted by subhasishray
    I need to import data from an excel file to a SQL SERVER databse with the help of BUlk insert utility (with out running a DTS).Can anybody tell me the code?I need to place the code in a Stored Procedure.

    Subhasish
    Bye
    Lorena

  3. #3
    Join Date
    Oct 2003
    Posts
    83
    Can I do it with the help of BCP?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    No, it needs to be a csv (or some delimited) or fixed width file...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

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

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    So either save the xls as csv or call the dts package from your stored procedure. Any reason why you do not want to use dts ?

Posting Permissions

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