• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

Update Excel data from Access query

Hi all,

I need a quick excel macro that would get data from an access query, and then update the data in excel where there is a match. The excel data has TAG_NO and MP_NO_E among the columns, and the query returns TAG_NO and MP_NO_A. For each TAG_NO that matches, I want to update MP_NO_E to MP_NO_A.
Thanks!
0
PopoDi
Asked:
PopoDi
  • 4
  • 2
2 Solutions
 
regmigrantCommented:
This probably doesnt need a macro - use the 'data connections' tab to set up a connection to Access and it will guide you through the extract
0
 
jmoss111Commented:
You can no longer update a linked Excel file in Access due to some copyright infringement issues from back in version 2000 or 2002.
0
 
PopoDiAuthor Commented:
I am not too familiar with programming excel. I can bring in the data from Access either through external data or manual export, but how do I do the updating where the TAG_NO matches?
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
jmoss111Commented:
If it were me, I would update in Access and then create a new Excel file
0
 
PopoDiAuthor Commented:
I thought about that, but I cannot. The data resides in the excel file and there is only the match in the two columns (Tag No and Mp No) with the access database. They want to have sort of a button that once clicked updates the Mp No from Access to Excel.
0
 
PopoDiAuthor Commented:
I was able to do it by just linking the excel file and the query in another access file and then just doing the update query. Thanks everyone who responded.
0
 
PopoDiAuthor Commented:
I am using my comments as a solution as the expert's comment spurred me in the direction of the ultimate solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now