Complicated Problem

Results 1 to 3 of 3

Thread: Complicated Problem

  1. #1
    Join Date
    Dec 1969

    Default Complicated Problem

    I have one table with columns<BR>A B C D E<BR>001 abab abab cada New<BR>002 bbbbb cccc ddd New<BR>003 cccc dddd eeee New<BR>One of my third party Customer will upload one document or excel file having records which may be or may not be same with the database column<BR>For example: (the format and the column can be define according to database)<BR>A E<BR>001 New<BR>003 New<BR>004 New<BR><BR>I have to compare this Word/excel documents records against database records and if records match need to update the database table column E the value New to Approved and whatever the records from document which doesn&#039;t match need to update dummy table for reference.<BR>For above case records 001 and 003 are same and have to update those 2 records in the database and move the last records 003 to dummy table for future reference.<BR><BR>My Question is How it can be possible do to in APS/SQL Server?<BR>Please can someone help me to find some solution?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default you've asked this before....

    ... and I answered you, IIRC. use the search function to find your original thread.

  3. #3
    Join Date
    Dec 1969

    Default do some research on

    connection to Excel through ODBC.<BR><BR>All you need is a couple of connections. One to Excel and the other to your DB (Access or whatever). Then you can form two recordsets based on your data.<BR><BR>And now you should be able to play around with it.<BR><BR>You may want to check the FAQ at 4guys. Another option would be a search on google.

Posting Permissions

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