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, 5 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…Bill
Viewing 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
-
Very Quarrelsome Taskbar!
by
CWBillow
6 hours, 7 minutes ago -
Move OneNote Notebook OFF OneDrive and make it local
by
CWBillow
8 hours, 51 minutes ago -
Microsoft 365 to block file access via legacy auth protocols by default
by
Alex5723
10 hours, 10 minutes ago -
Is your battery draining?
by
Susan Bradley
7 minutes ago -
The 16-billion-record data breach that no one’s ever heard of
by
Alex5723
12 hours, 7 minutes ago -
Weasel Words Rule Too Many Data Breach Notifications
by
Nibbled To Death By Ducks
12 hours, 43 minutes ago -
Windows Command Prompt and Powershell will not open as Administrator
by
Gordski
15 hours, 58 minutes ago -
Intel Management Engine (Intel ME) Security Issue
by
PL1
6 hours, 41 minutes ago -
Old Geek Forced to Update. Buy a Win 11 PC? Yikes! How do I cope?
by
RonE22
37 minutes ago -
National scam day
by
Susan Bradley
12 hours, 8 minutes ago -
macOS Tahoe 26 the end of the road for Intel Macs, OCLP, Hackintosh
by
Alex5723
17 minutes ago -
Cyberattack on some Washington Post journalists’ email accounts
by
Bob99
1 day, 13 hours ago -
Tools to support internet discussions
by
Kathy Stevens
2 hours, 28 minutes ago -
How get Group Policy to allow specific Driver to download?
by
Tex265
1 day, 4 hours ago -
AI is good sometimes
by
Susan Bradley
1 day, 20 hours ago -
Mozilla quietly tests Perplexity AI as a New Firefox Search Option
by
Alex5723
1 day, 11 hours ago -
Perplexity Pro free for 12 mos for Samsung Galaxy phones
by
Patricia Grace
2 days, 21 hours ago -
June KB5060842 update broke DHCP server service
by
Alex5723
2 days, 19 hours ago -
AMD Ryzen™ Chipset Driver Release Notes 7.06.02.123
by
Alex5723
2 days, 23 hours ago -
Excessive security alerts
by
WSSebastian42
1 day, 14 hours ago -
* CrystalDiskMark may shorten SSD/USB Memory life
by
Alex5723
3 days, 9 hours ago -
Ben’s excellent adventure with Linux
by
Ben Myers
2 hours, 13 minutes ago -
Seconds are back in Windows 10!
by
Susan Bradley
2 days, 20 hours ago -
WebBrowserPassView — Take inventory of your stored passwords
by
Deanna McElveen
1 day, 14 hours ago -
OS news from WWDC 2025
by
Will Fastie
1 day ago -
Need help with graphics…
by
WSBatBytes
2 days, 4 hours ago -
AMD : Out of Bounds (OOB) read vulnerability in TPM 2.0 CVE-2025-2884
by
Alex5723
4 days ago -
Totally remove or disable BitLocker
by
CWBillow
2 days, 23 hours ago -
Windows 10 gets 6 years of ESU?
by
n0ads
3 days, 3 hours ago -
Apple, Google stores still offer China-based VPNs, report says
by
Nibbled To Death By Ducks
4 days, 11 hours 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.