+ Reply to Thread
Results 1 to 1 of 1

macro in excel to find value in access or Mysql and validate if exist or not

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    99

    macro in excel to find value in access or Mysql and validate if exist or not

    Hi master's!

    I have a problem!!..

    I need a macro to:
    1) find a value (item) in an access database and return the legend: if found-> "found" or "not found".
    2)That also doesn't have a data range, it's neccesary to search in all active cells in excel. (variable range of dates depending the data)
    3)Alternative, I have a MySql database with the same database, but I don't know how find the value..

    I'm create the connection to access database, but I don't know the function for this process..

    I appreciate your effort to help me, Thank you very much!

    Attach the files:
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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