data migration (import data) from MS ACCESS to SQL SERVER

Question

I need to migrate data from ms access to sql server daily to accomplish this is there any sql script or any...  Please help me doing this

Note:Database exists in the sql server and tables with same names as in ms access also available in the sql server

Thanks in advance,

Praveen Kumar Palla.

Answer 1

Hi,

there is a Migration-Tool, for more information plz read : Access migration using SSMA (Whitepaper) .

SSMA Access for SQL Server 2008
SSMA Access for SQL Server 2005

---

I wish you a nice day,

Torsten Schuessler

Answer 2

Hi
Thanks for the reply
I've installed SSMA and created one project in SSMA to migrated the selected tabled data into selected sql server tables

I need to migrate the data from access to sql server daily morning do i need to run the project daily or can we write any script and some thing to make automated

Thanks in advance
Praveen Kumar Palla.