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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!