troubleshooting Question

Update Excel worksheet with results from Access table using VBA

Avatar of SASnewbie
SASnewbie asked on
Microsoft ExcelMicrosoft AccessVB ScriptVBA
11 Comments1 Solution61 ViewsLast Modified:
Hello Experts,
I need assistance in writing VBA to transfer data from an access table to specific cells in an existing Excel file. This process is updating the worksheet with results from Access.
Below is an example of what I am trying to do, update the worksheet in the M&I Notes cells with the comment “ADD “ & EFF_DT.
Access table:

POSITION NO      EMPLID      FULL NAME            POSITION TYPE      EFF_DT
1234567                     1000001      LAST, FIRST            Team Member      3/6/2016
2345678                     1000002      LAST, SECOND    Team Member      3/6/2016
3456789                     1000003      LAST, THIRD            Team Member      3/10/2016
4567891                     1000004      LAST, FOURTH     Team Member      3/14/2016
5678912                     1000005      LAST, SIXTH            Team Member      3/14/2016

Excel Workbook:
                  
Position Type      M&I Notes      POSITION NO      EMPLID      FULL NAME
Team Member                             1234567                     1000001      LAST, FIRST
Team Member                             2345678                     1000002      LAST, SECOND
Team Member                             3456789                   1000003      LAST, THIRD
Team Member                             4567891                     1000004      LAST, FOURTH
Team Member                             5678912                     1000005      LAST, FIFTH

Ultimate results:
            
Position Type      M&I Notes      POSITION NO      EMPLID      FULL NAME
Team Member       ADD 3/6/2016      1234567              1000001      LAST, FIRST
Team Member       ADD 3/6/2016      2345678              1000002      LAST, SECOND
Team Member       ADD 3/10/2016      3456789              1000003      LAST, THIRD
Team Member       ADD 3/14/2016      4567891              1000004      LAST, FOURTH
Team Member       ADD 3/14/2016      5678912              1000005      LAST, FIFTH

Thanks in advance.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros