+ Reply to Thread
Results 1 to 2 of 2

Check if data in excelsheet is present in Access table. if yes then update Access table.

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Check if data in excelsheet is present in Access table. if yes then update Access table.

    Hi All

    I have a userform where when the user clicks on the browse button then filepath gets stored in the textbox as below:
    Please Login or Register  to view this content.
    Please see attached the excel workbook. Now in that file , the first sheetname will always be "Summary". So i want VBA code that will check if the data in Column D in sheet "Summary" is present in field "Reference" of Access table "tblliterature" . if its present then check in the Summary sheet , which corresponding fields out of "Withdrawn","Obsolete" and "Updated" stores "Y" .
    If Withdrawn column value is "Y" then change the status of corresponding record of tblliteraure to "Withdrawn"
    If Obsolete column value is "Y" then change the status of corresponding record of tblliteraure to "Obsolete"
    If Updated column value is "Y" then change the status of corresponding record of tblliteraure to "Updated"

    Any help would be much appreciated.

    Thanks
    Attached Files Attached Files
    Last edited by aman1234; 11-27-2014 at 10:00 AM.

  2. #2
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Re: Check if data in excelsheet is present in Access table. if yes then update Access tabl

    Hi All

    Can anyone pls help me in this??? Its very urgent to resolve.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Check if the value in textbox is present in Access table using vba
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-16-2014, 09:42 AM
  2. Check if column D value is present in Access table Ref Field VBA
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2014, 06:01 AM
  3. Replies: 2
    Last Post: 09-03-2014, 03:37 AM
  4. [SOLVED] Check Policy Number in Access table and populate related data in Excelsheet using vba
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-14-2014, 09:47 AM
  5. Extract data from Access table into excelsheet
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2012, 05:36 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1