Sql server Question?

Results 1 to 2 of 2

Thread: Sql server Question?

  1. #1
    Join Date
    Dec 1969

    Default Sql server Question?

    I am new to SQL server, In a Sql database I have a Clients table with clients information which include there account number and account amount. I get a daily email in excel format from a 3rd party with clients account numbers and updated account totals. What I want to do is update the sql table with the updated amounts in the excel sheet. The common key is the account number. Is there a way to do this in SQL. Also this is something I will have to run on a daily bases. What would be the best solution?

  2. #2
    Join Date
    Dec 1969

    Default RE: Sql server Question?

    DTS or BCP

Posting Permissions

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