BCP

  • 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]

  • Go throught the link below which will help you.

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

    Regards

    Srinivas Chilakapati

  • 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