Access Data Project Table Update

[TJC]

I currently have a database that has been upsized to Microsoft SQL server. I administer the content of the tables
locally with an Access 97 database. Rather then re-creating all the forms in ADP, I want to create a stored procedure or some other function to periodically update the SQL tables with the content in my local Access .mdb tables. Has someone written an automated procedure that they can post that will allow me to perform this task?

 

[jfischer]

The simplest approach to this requirement is to use the DTS Import/Export Wizard that comes with SQL Server to design a package that can be saved in SQL Server and scheduled to run automatically and unattended.

 

[TJC]

I was hoping to maintain local control over when the tables are updated. The table content doesn't change on a routine basis. Can I execute some procedure out of adp?