[AccessD] Is Direct Update/Append Possible from Excel

Keith Williamson KWilliamson at designcollective.com
Wed Mar 3 10:51:00 CST 2021 

Thanks Jim...but the link you posted, I can't get to any site with.  Do you have something in mind?

Many 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



-----Original Message-----
From: AccessD <accessd-bounces+kwilliamson=designcollective.com at databaseadvisors.com> On Behalf Of Jim Dettman via AccessD
Sent: Monday, March 01, 2021 9:46 AM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Subject: Re: [AccessD] Is Direct Update/Append Possible from Excel


[THIS EMAIL IS FROM AN EXTERNAL SENDER]

Keith,

  It really is not much different than if you were doing it from Access and read/writing an external database.

 The only thing is that you need to open the database:

  Set daoDB = DBEngine.Workspaces(0).OpenDatabase(strDB)

  And you are off and running.  Examples of all the various logic can be found here:


https://urldefense.proofpoint.com/v2/url?u=https-3A__www.excelanytime.com_excel_index.php-3Foption-3Dcom-5Fcontent-26view-3Darticle&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=cKevqucH6puU6_b5EXeV87w76OVwD0tlWNAz7m5R60c&e=
&id=175:connecting-to-microsoft-access-database-from-excel-vba-using-dao-obj
ect-model&catid=79&Itemid=475

Jim.

-----Original Message-----
From: AccessD On Behalf Of Keith Williamson
Sent: Monday, March 1, 2021 9:16 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Is Direct Update/Append Possible from Excel

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=cCa049KXg2Due8I6xkX
zoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=R65
r23iWBUAKFdc_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_ma
ilman_listinfo_accessd&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiM
M&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m
1JxiCcswjwUEEInlk&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=cCa049KXg2Due8I6xk
XzoVrfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=B0
Jxkk-_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=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=R09No-M8L9AUDQMoWH5yCiNg_wVdAaZn3287lORMdc0&e=
Website: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadvisors.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=yTcSfXExiKpzWtz60a35Xmitelf_UmpPCLYozKN3klU&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=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=R09No-M8L9AUDQMoWH5yCiNg_wVdAaZn3287lORMdc0&e=
Website: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadvisors.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=yTcSfXExiKpzWtz60a35Xmitelf_UmpPCLYozKN3klU&e=

More information about the AccessD mailing list