L
Larry A
I've done this before, but I can't find any of my old examples for
reference. I would like to execute an action query in Access from Excel
using a VBA macro
1. The Excel spreadsheet has a range defined as a linked table into the
Access app.
2. And there are two append queries in Access that will append data from
the linked range periodically to a physical table in Access.
2. And, what I would like to so is, from within Excel, without having
Access up and running, connect to the database, execute the query, and close
the database as needed.
What might be a good way to approach? Thanks in advance. Larry.
reference. I would like to execute an action query in Access from Excel
using a VBA macro
1. The Excel spreadsheet has a range defined as a linked table into the
Access app.
2. And there are two append queries in Access that will append data from
the linked range periodically to a physical table in Access.
2. And, what I would like to so is, from within Excel, without having
Access up and running, connect to the database, execute the query, and close
the database as needed.
What might be a good way to approach? Thanks in advance. Larry.