I have a large database on ms access with more than 100 tables.
I am planning to do migrate this database into MS SQL Server 2005.
I am receiving info into database access on a daily basis.
So I have to do an auto job to import data from access into SQL Server 2005.
I think that creating a stored procedure to have an automated job per day may fit my aim, do you have any idea about how can I do it?
Please a help waiting your reply as soon as possible!