Run Access macro from SQL

[jmj]

I have some tables that have to sit in an Access database. I have a macro that takes all these tables and updates them into a SQL linked table.
I would like to set it up so that the Access macro is run from a sql stored procedure.
Is this possible?
Or is there a different/better way.
Thanks,
J

 

[SQLDenis]

Let me get this straight

you want to run a macro from sql that then updates the tables in a sql DB?

why not run thr update straight from SQL, perhaps a proc that is scheduled??

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jmj]

Here's the steps of what I want it to do
1. dump all the data from the sql table.
2. Run a macro in Access that takes linked Dbase4 tables (dbase4 linked to Access) and appends them to the linked sql database table.

Our system uses a dbase 4 databases- each location has it's own copy of the database to track their own clients. I need to dump all 16 locations information into one sql table. I already have all the dbase 4 tables linked to an access database for other queries that we use against the dbase 4 tables. So I wrote a quick macro that will append each tables data into the sql table.

I'd like the macro to either be triggered by a stored procedure or some scheduler that is set in sql since access doesn't have a scheduler.
Does that make sense-
thanks,
j