Solved

update records with import process

Posted on 2012-04-12
2
225 Views
Last Modified: 2012-04-12
hello,
i am attaching database example and excel sheet.
If you open database and click [import DATA] button on form.
Browse to the excel sheet- and the data is imported into tblOne successfully.

Is there a way to modify this code - When data is imported in tblOne -It only Updates records that have same AutoNum?
( does not import records that have null value in AutoNum field or have AutoNum that does not match).


Thank you
Import-Data-E-.accdb
tblOne.xlsx
0
Comment
Question by:davetough
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 37839593
you need to import the new records to a temp table, then
run an update query  with your criteria using the temp table as source
 and
run an append query  with your criteria
0
 

Author Closing Comment

by:davetough
ID: 37839741
thanks cap
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access, Class Objects, Modules, Class Modules 6 38
Null or "" 28 53
Populate a MS Access field based on contents of 2 other fields. 5 29
SQL Server Compression Decision 5 49
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question