What syntax do I need to use to fire off an Access Macro through MS-SQL DTS? (Basically MS-SQL DTS passes a SQL statement to Access through its Jet32 drivers.)<BR>If this was MS-SQL, the command would ...
I'm attempting to automate a process at my job where we import data into an Access Database, run a series of queries to modify the data, then export the modified data. What I'm attempting to do is ...