Solved

update records with import process

Posted on 2012-04-12
2
221 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
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

770 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