[AccessD] Is Direct Update/Append Possible from Excel

[Rocky Smolin]

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
(access-templates.com)
<https://database.access-templates.com/how-to-update-access-database-from-ms-excel.html>

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://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>