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…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
-
Acronis : Tracking Chaos RAT’s evolution (Windows, Linux)
by
Alex5723
3 hours, 38 minutes ago -
Turning off OneDrive
by
CWBillow
8 hours, 8 minutes ago -
June 2025 updates are out
by
Susan Bradley
12 minutes ago -
Mozilla shutting Deep Fake Detector
by
Alex5723
18 hours, 25 minutes ago -
Windows-Maintenance-Tool (.bat)
by
Alex5723
3 hours, 47 minutes ago -
Windows 11 Insider Preview build 26200.5641 released to DEV
by
joep517
20 hours, 57 minutes ago -
Windows 11 Insider Preview build 26120.4250 (24H2) released to BETA
by
joep517
20 hours, 59 minutes ago -
Install Office 365 Outlook classic on new Win11 machine
by
WSrcull999
20 hours, 56 minutes ago -
win 10 to win 11 with cpu/mb replacement
by
aquatarkus
12 hours, 49 minutes ago -
re-install Windows Security
by
CWBillow
1 day ago -
WWDC 2025 Recap: All of Apple’s NEW Features in 10 Minutes!
by
Alex5723
1 day, 3 hours ago -
macOS Tahoe 26
by
Alex5723
22 hours, 8 minutes ago -
Migrating from win10 to win11, instructions coming?
by
astro46
10 hours, 12 minutes ago -
Device Eligibility for Apple 2026 Operating Systems due this Fall
by
PKCano
12 hours, 40 minutes ago -
Recommended watching : Mountainhead movie
by
Alex5723
13 hours, 24 minutes ago -
End of support for Windows 10
by
Old enough to know better
13 hours, 20 minutes ago -
What goes on inside an LLM
by
Michael Covington
7 hours, 34 minutes ago -
The risk of remote access
by
Susan Bradley
3 hours, 13 minutes ago -
The cruelest month for many Office users
by
Peter Deegan
19 hours, 37 minutes ago -
Tracking protection and trade-offs in Edge
by
Mary Branscombe
17 hours, 39 minutes ago -
Supreme Court grants DOGE access to confidential Social Security records
by
Alex5723
2 days, 2 hours ago -
EaseUS Partition Master free 19.6
by
Alex5723
1 day, 2 hours ago -
Microsoft : Edge is better than Chrome
by
Alex5723
2 days, 15 hours ago -
The EU launched DNS4EU
by
Alex5723
3 days, 4 hours ago -
Cell Phone vs. Traditional Touchtone Phone over POTS
by
280park
2 days, 18 hours ago -
Lost access to all my networked drives (shares) listed in My Computer
by
lwerman
3 days, 9 hours ago -
Set default size for pasted photo to word
by
Cyn
3 days, 15 hours ago -
Dedoimedo tries 24H2…
by
Cybertooth
3 days, 3 hours ago -
Windows 11 Insider Preview build 27871 released to Canary
by
joep517
4 days, 14 hours ago -
Windows 11 ad from Campaign Manager in Windows 10
by
Jim McKenna
2 days, 7 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.