Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Location
    Port Talbot, Wales
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Appending a Text Database Using SQL (Office '97)

    CAn anyone please tell me the SQL Code for appending a database (Call_Centre.txt) that has the fields ActionDate, Local_Office, Faxes, Trans_Calls, NSC, SC with another database (Call_Centre_NewData.txt) containing the new data. Sample File Attached!

    Thanks
    Jamie
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Appending a Text Database Using SQL (Office '97)

    Both files you mention have text extensions. Where does Access come into this? Or are you talking about tables?
    Charlotte

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Appending a Text Database Using SQL (Office '97)

    Charlotte, I don't know if Access comes into this, but I moved the question here (from General Office Solutions) since Jamie asks for SQL. This forum seemed most appropriate for questions concerning SQL.

Posting Permissions

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