I would like to update records to the deceased section in access from a excel spreadsheet.
I have a access dbase with patient #, name, and a deceased date. The Excel spreadsheet is setup the same way. Every month I get a excel deceased spreadsheet. How can I add the date of death from the excel spreadsheet to my access deceased date section? Please help I just manually typed in over 200 deceased dates. I’m using Access 2003
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Update records from excel into access
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Update records from excel into access
- This topic has 7 replies, 4 voices, and was last updated 11 years, 4 months ago.
AuthorTopicWSbuckshot
AskWoody LoungerSeptember 2, 2011 at 7:36 am #478757Viewing 4 reply threadsAuthorReplies-
RetiredGeek
AskWoody_MVPSeptember 2, 2011 at 11:17 am #1296140Buckshot,
What you want to do is:
-
[*]Link the Spreadsheet as an external data source.
[*]Write an Update Query that does the following:[*]Links the two tables {Access & Excel} on the Patient#
[*]Set the link so it shows only matches between the two tables.
[*]Update the Deceased date field in the Access table using the data from Excel.[/LIST]
This is a general outline of what needs to be done. If you need more detailed help please post back. :cheers:Update: Ok I’ve tested, using Excel 2007 but will be basically the same for all versions, and added graphics {make sure to click on graphics to see the whole thing} to show the entire process. Note the XLS file is the last graphic but I should have posted it first. :cheers:
-
WSbuckshot
AskWoody Lounger
-
RetiredGeek
AskWoody_MVPSeptember 3, 2011 at 7:23 am #1296299Buckshot,
You’re welcome. :cheers:
WSBillBloxam
AskWoody LoungerJanuary 9, 2014 at 6:54 am #1432974RG…Wonder if you can assist an old Aussie with this. I have an Access (2010) tblBookings with a DateCompleted field. In an Excel (2010) Template I have a linked tbl to the Access Dbase. I would like to enter a date into the Excel DateCompleted field in the Excel linked tbl and have it update the Access Date completed field. Is the problem I have related to the fact the Excel file is a “Template”……which is after completion saved under a different name ? Many Thanks
-
RetiredGeek
AskWoody_MVPJanuary 9, 2014 at 7:47 am #1432975Is the problem I have related to the fact the Excel file is a “Template”……which is after completion saved under a different name ? Many Thanks
Bill,
Welcome to the Lounge as a new poster. :cheers:
Yes, if you use a different name each time you will have to change the file name in the update query. HTH
BTW: It is proper Lounge etiquette to start a new thread with a new question and not add on to an existing one.
:cheers:
WBell
AskWoody_MVPJanuary 9, 2014 at 4:53 pm #1433115Well, since this appears to have evolved into an old guys thread, I’ll chime in (not sure who is older, but I’ve been around this forum for well over a decade). If you are working repeatedly with different Excel workbooks, linking to them may not be the best solution. You might instead create a VBA procedure that automated Excel from Access, and let’s you use DAO or ADO to update the appropriate record. It’s not a subject for the total novice to consider, but if you have some VBA skills, it opens up some additional options for move data between Excel and Access. If you want to explore the subject of automation, have a look at our Automation 101 tutorial. We use that technique to create some very complex reports for specific recipients in Excel, and then email them to the recipient (using automation of Outlook of course).
WSBillBloxam
AskWoody LoungerJanuary 12, 2014 at 1:49 am #1433358RG & Wendell,
Many thanks. Having some success by putting data in a separate XL file and updating Access from there. The Access file presently only gets 1 field update from 1 XL file. This coul change of course if I ever get up to speed . Like the idea of the DAO or ADO update but as a novice will have to burn some midnight oil. Appreciate the tip on the Tutorial and will give it a try.
Thanks again…BillViewing 4 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Windows 11 Insider Preview build 27871 released to Canary
by
joep517
15 hours, 40 minutes ago -
Windows 11 ad from Campaign Manager in Windows 10
by
Jim McKenna
13 hours, 1 minute ago -
Small desktops
by
Susan Bradley
5 hours, 53 minutes ago -
Totally disable Bitlocker
by
CWBillow
14 hours, 2 minutes ago -
Phishers extract Millions from HMRC accounts..
by
Microfix
13 hours, 17 minutes ago -
Windows 10 22H2 Update today (5 June) says up-to-date but last was 2025-04
by
Alan_uk
1 day, 19 hours ago -
Thoughts on Malwarebytes Scam Guard for Mobile?
by
opti1
2 hours, 46 minutes ago -
Mystical Desktop
by
CWBillow
1 day, 22 hours ago -
Meta and Yandex secretly tracked billions of Android users
by
Alex5723
1 day, 4 hours ago -
MS-DEFCON 2: Do you need that update?
by
Susan Bradley
14 hours, 51 minutes ago -
CD/DVD drive is no longer recognized
by
WSCape Sand
2 days, 14 hours ago -
Windows 11 24H2 Default Apps stuck on Edge and Adobe Photoshop
by
MikeBravo
2 days, 16 hours ago -
North Face and Cartier customer data stolen in cyber attacks
by
Alex5723
2 days, 15 hours ago -
What is wrong with simple approach?
by
WSSpoke36
13 hours, 8 minutes ago -
Microsoft-Backed Builder.ai Set for Bankruptcy After Cash Seized
by
Alex5723
3 days, 2 hours ago -
Location, location, location
by
Susan Bradley
1 day, 16 hours ago -
Cannot get a task to run a restore point
by
CWBillow
3 days, 3 hours ago -
Frustrating search behavior with Outlook
by
MrJimPhelps
2 days, 18 hours ago -
June 2025 Office non-Security Updates
by
PKCano
3 days, 14 hours ago -
Secure Boot Update Fails after KB5058405 Installed
by
SteveIT
1 day, 17 hours ago -
Firefox Red Panda Fun Stuff
by
Lars220
3 days, 14 hours ago -
How start headers and page numbers on page 3?
by
Davidhs
4 days, 1 hour ago -
Attack on LexisNexis Risk Solutions exposes data on 300k +
by
Nibbled To Death By Ducks
3 days, 3 hours ago -
Windows 11 Insider Preview build 26200.5622 released to DEV
by
joep517
4 days, 9 hours ago -
Windows 11 Insider Preview build 26120.4230 (24H2) released to BETA
by
joep517
4 days, 9 hours ago -
MS Excel 2019 Now Prompts to Back Up With OneDrive
by
lmacri
3 days, 23 hours ago -
Firefox 139
by
Charlie
3 days, 15 hours ago -
Who knows what?
by
Will Fastie
2 days, 18 hours ago -
My top ten underappreciated features in Office
by
Peter Deegan
20 hours, 56 minutes ago -
WAU Manager — It’s your computer, you are in charge!
by
Deanna McElveen
6 hours, 50 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.