[AccessD] Is Direct Update/Append Possible from Excel

[Keith Williamson]

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=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=R65r23iWBUAKFdc_YDA3RIh5N7Tyk8YSx4PqZO-3Mag&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=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&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=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-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=1iTMHjrE4JZBqbEMf_uiuzi9wre3SBmPbe4qnZym-Zk&e=
Website: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadvisors.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=B0Jxkk-_Ke91druZqyaDgaE6SxhLuU_B3BTouIFG0Lc&e=