MS SQL 2005 to Access 2003 via ODBC
Posted on 2009-05-13
I have a database in MS SQL Server 2005 that from time to time needs to have some tables brought into Microsoft Access.
I have no problem doing this using a DSN and importing but every time I do it I have to make a new Access database and set up my table relationships all over again which is time consuming.
Is there a way I can ideally ust update my current access database with the new records from my SQL Server 2005 database, or if not somehow save my relationships so I can apply them to the new Access Database?
Any help, thoughts, suggestions is appreciated.