Run Access Function from Excel without opening database

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,277
What does the function in Access actually do?

If you want to insert data into Access from Excel without opening the database you should look at using ADO.
 

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,313
The function in Access triggers another macro that updates records into a table from data imported from Excel.

Apart from testing feedback, the project is complete, I left the code as was with it opening the database
 

Forum statistics

Threads
1,077,721
Messages
5,335,816
Members
399,051
Latest member
WPO

Some videos you may like

This Week's Hot Topics

Top