Post reply

BCP

  • March 26, 2008 at 10:59 am

    #187716

    Does BCP is used to transfer data only from txt files or will it support transfering data from excel file to sql server table?

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • March 27, 2008 at 3:57 am

    #794492

    Go throught the link below which will help you.

    http://support.microsoft.com/kb/321686

    Regards

    Srinivas Chilakapati

  • March 28, 2008 at 12:50 pm

    #795410

    You can't directly bcp in an Excel spreadsheet, but you can always save the spreadsheet as a .csv or tab-delimted text file and then bcp that file in, using the appropriate row and field terminators.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply