As updating an ms access db Reg sex girle
This example is using SQL Server 2008 R2, but it should work with SQL 2005 and SQL 2008 as well.
You will need to have SSIS and MS Access installed.
Fortunately, Microsoft Access (MS-Access) supports ODBC. This HOW-TO takes you step by step through the process of linking OOo to MS-Access using ODBC.
The process has three simple steps: dialogue box: Give the new data source a name (e.g.
the same name as your MS-Access database) and a description.
In this tip, we are going to walk through step by step how to migrate a MS Access table to SQL Server using SQL Server Integration Services (SSIS).
The tip assumes that the readers have none to little experience with MS Access and SQL Server Integration Services (SSIS).