Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
forums_4m
Starting Member
1 Post |
 Posted - 2008-05-02 : 05:47:48
|
| Hi SQL Team,Data migration from MS access to Sql server 2005.In client having existing system is MS Access. So I want to migration MS Access system to SQL server 2005.Let suppose there MS Access one table having 10 fields.That table data i need migrate in system (sql server 2005), but the field name are different & sql server few fields are extra suppose 15 fields or vise versa.So can any one help me out, how to migrate the MS access to sql server system?Please give me if any one the script or step do this.Thanks & regards |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 20:17:39
|
| You can try with data import wizard. |
 |
|
|
|
|
|
How Migrate from MS Access to SQL Server 2005?