[AccessD] Is Direct Update/Append Possible from Excel

Wed Mar 3 10:56:51 CST 2021

Sorry, this one:

https://www.excelanytime.com/excel/index.php?option=com_content&view=article
&id=175:connecting-to-microsoft-access-database-from-excel-vba-using-dao-obj
ect-model&catid=79&Itemid=475

Should get you there.

Jim.

-----Original Message-----
From: AccessD On Behalf Of Keith Williamson
Sent: Wednesday, March 3, 2021 11:51 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

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_ex
cel_index.php-3Foption-3Dcom-5Fcontent-26view-3Darticle&d=DwICAg&c=euGZstcaT
DllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M
_3qY&m=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=cKevqucH6puU6_b5EXeV87w
76OVwD0tlWNAz7m5R60c&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-2Dtemp
lates.com_how-2Dto-2Dupdate-2Daccess-2Ddatabase-2Dfrom-2Dms-2Dexcel.html&d=D
wICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=cCa049KXg2Due8I6xkXzoV
rfvG83jjeYLf7LB9M_3qY&m=xOwCf8zqoYT1Xt2rt0SZgCVc0m1JxiCcswjwUEEInlk&s=MOJOWb
gZ8DRHiQxipOy8JQGxfOqJj2LmJLrCbrIuxuc&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_ma
ilman_listinfo_accessd&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiM
M&r=cCa049KXg2Due8I6xkXzoVrfvG83jjeYLf7LB9M_3qY&m=4QFxNyzD-K4d0iusGvx7lWqUYh
BVY1IUJ-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=cCa049KXg2Due8I6xk
XzoVrfvG83jjeYLf7LB9M_3qY&m=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=yT
cSfXExiKpzWtz60a35Xmitelf_UmpPCLYozKN3klU&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=4QFxNyzD-K4d0iusGvx7lWqUYh
BVY1IUJ-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=cCa049KXg2Due8I6xk
XzoVrfvG83jjeYLf7LB9M_3qY&m=4QFxNyzD-K4d0iusGvx7lWqUYhBVY1IUJ-2EkCv2-h0&s=yT
cSfXExiKpzWtz60a35Xmitelf_UmpPCLYozKN3klU&e=
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com