[AccessD] Is Direct Update/Append Possible from Excel

Wed Mar 3 10:41:11 CST 2021

Thanks Rocky.  I'll start with this link

Keith E. Williamson
Chief Financial Officer

601 East Pratt Street, Suite 300
Baltimore, Maryland 21202
Tel 410.685.6655  | 100% Employee-Owned Design Firm
www.designcollective.com

-----Original Message-----
From: AccessD <accessd-bounces+kwilliamson=designcollective.com at databaseadvisors.com> On Behalf Of Rocky Smolin
Sent: Monday, March 01, 2021 10:52 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Is Direct Update/Append Possible from Excel

[THIS EMAIL IS FROM AN EXTERNAL SENDER]

I just tried that link and it didn't go to the same page I was looking at.
Try this one:

How to Update Access Database from Ms Excel | Access Database and Templates
(https://urldefense.proofpoint.com/v2/url?u=http-3A__access-2Dtemplates.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=lKoRwH-f3MYqf_LGpoPEzCDtQyCJDY6nu-TAwcJF4R0&s=t3nH2wYhNG5urH8WGZHqE_XsZk7hC85LitHfskJU7mc&e=)
<https://urldefense.proofpoint.com/v2/url?u=https-3A__database.access-2Dtemplates.com_how-2Dto-2Dupdate-2Daccess-2Ddatabase-2Dfrom-2Dms-2Dexcel.html&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=lKoRwH-f3MYqf_LGpoPEzCDtQyCJDY6nu-TAwcJF4R0&s=KKLYSAEV-7O7W2cfBSdOmf7JdV7iQ5WwVIscSP630Uo&e=>

Otherwise, I got there by googling 'how to update access database from excel'.

Most of the code behind my Excel sheet I got by recording a macro and cribbing the code generated. GOt a lot of automation code in Access the same way when I had to format a spreadsheet.

HTH

Rocky

On Mon, Mar 1, 2021 at 6:16 AM Keith Williamson < KWilliamson at designcollective.com> wrote:

> Thanks Rocky.  I'm going to have to go with vba code anyway (for other 
> functionality), so code to push it up is not a concern.  Just what I 
> googled, I could not find an example of code to get me going in the 
> right direction.  I'll look at the link you sent....maybe that can get 
> me in the right direction.  If there is a manual way to do this 
> (within Excel)....I can capture that in the code and modify for my needs.
>
> Many thanks for your time.
>
> Keith E. Williamson
> Chief Financial Officer
>
> 601 East Pratt Street, Suite 300
> Baltimore, Maryland 21202
> Tel 410.685.6655  | 100% Employee-Owned Design Firm 
> www.designcollective.com
>
>
>
> -----Original Message-----
> From: AccessD <accessd-bounces+kwilliamson= 
> designcollective.com at databaseadvisors.com> On Behalf Of Rocky Smolin
> Sent: Friday, February 26, 2021 4:47 PM
> To: Access Developers discussion and problem solving < 
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Is Direct Update/Append Possible from Excel
>
>
> [THIS EMAIL IS FROM AN EXTERNAL SENDER]
>
> It can be done with some VBA code. Actually, I discovered that 
> anything you can do with any of the Suite apps through the UI can be 
> done in code. I wrote an app once where I had code behind an Excel 
> page which pushed data into an access back end.
>
> But if you don't want to go the code route this may help?
>
> How to Update Access Database from Ms Excel | Access Database and 
> Templates ( 
> https://urldefense.proofpoint.com/v2/url?u=http-3A__access-2Dtemplates
> .com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KX
> g2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCc
> swjwUEEInlk&s=R65r23iWBUAKFdc_YDA3RIh5N7Tyk8YSx4PqZO-3Mag&e=
> )
> <
> https://urldefense.proofpoint.com/v2/url?u=https-3A__database.access-2
> Dtemplates.com_how-2Dto-2Dupdate-2Daccess-2Ddatabase-2Dfrom-2Dms-2Dexc
> el.html&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa04
> 9KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1Jx
> iCcswjwUEEInlk&s=MOJOWbgZ8DRHiQxipOy8JQGxfOqJj2LmJLrCbrIuxuc&e=
> >
>
> Best,
>
> Rocky
>
>
> On Fri, Feb 26, 2021 at 1:40 PM Keith Williamson < 
> KWilliamson at designcollective.com> wrote:
>
> > Hi guys,
> >
> > Is it possible to do a direct append or update from excel to a table 
> > in Access?  Or can that only be done from within Access?
> >
> > Thanks
> >
> > Keith E. Williamson
> > Chief Financial Officer
> >
> > 601 East Pratt Street, Suite 300
> > Baltimore, Maryland 21202
> > Tel 410.685.6655  | 100% Employee-Owned Design Firm 
> > www.designcollective.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://urldefense.proofpoint.com/v2/url?u=https-3A__databaseadvisors.
> > com_mailman_listinfo_accessd&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-
> > v5 
> > A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8
> > zq 
> > oYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=1iTMHjrE4JZBqbEMf_uiuzi9wre3SB
> > mP
> > be4qnZym-Zk&e=
> > Website:
> > https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadvi
> > so
> > rs.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa0
> > 49 
> > KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1J
> > xi CcswjwUEEInlk&s=B0Jxkk-_Ke91druZqyaDgaE6SxhLuU_B3BTouIFG0Lc&e=
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__databaseadvisors.
> com_mailman_listinfo_accessd&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5
> A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zq
> oYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=1iTMHjrE4JZBqbEMf_uiuzi9wre3SBmP
> be4qnZym-Zk&e=
> Website:
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadviso
> rs.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049
> KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1Jxi
> CcswjwUEEInlk&s=B0Jxkk-_Ke91druZqyaDgaE6SxhLuU_B3BTouIFG0Lc&e=
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://urldefense.proofpoint.com/v2/url?u=https-3A__databaseadvisors.
> com_mailman_listinfo_accessd&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5
> A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=lKoRwH-f
> 3MYqf_LGpoPEzCDtQyCJDY6nu-TAwcJF4R0&s=05jK3kbMSdewvX86ZZoZP8dLyyydhAt_
> t3q6qSeWZAs&e=
> Website: 
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadviso
> rs.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049
> KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=lKoRwH-f3MYqf_LGpoPEzCDtQyCJDY
> 6nu-TAwcJF4R0&s=zCek52-fJRiMZyxwniaicwCrb45t6kMl1hCai9mgDNo&e=
>
--
AccessD mailing list
AccessD at databaseadvisors.com
https://urldefense.proofpoint.com/v2/url?u=https-3A__databaseadvisors.com_mailman_listinfo_accessd&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=lKoRwH-f3MYqf_LGpoPEzCDtQyCJDY6nu-TAwcJF4R0&s=05jK3kbMSdewvX86ZZoZP8dLyyydhAt_t3q6qSeWZAs&e=
Website: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadvisors.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=lKoRwH-f3MYqf_LGpoPEzCDtQyCJDY6nu-TAwcJF4R0&s=zCek52-fJRiMZyxwniaicwCrb45t6kMl1hCai9mgDNo&e=