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 |
|
joti
Starting Member
1 Post |
 Posted - 2006-11-23 : 22:59:08
|
| Can anyone give me some ideas on how can i transfer data from access database to sql 2005. It is bit complicated any help will be highly appreciated. |
|
|
gsgill76
Posting Yak Master
137 Posts |
Posted - 2006-11-24 : 00:40:28
|
| JotiImport/Export will help you (DTS).In the SSMS1) Right click on the database name(this you need to create yourself) to which you want to import the data.2) Select the Tasks3) Select the Import Data..Next you will find,Import/Export Wizard, here you need to set the source database & destination Database. Rest will SQL Server-2005 will doGurpreet S. Gill |
 |
|
|
|
|
|
Transferring database from access 97 to sql 2005