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 |
|
soori457
Yak Posting Veteran
85 Posts |
 Posted - 2009-06-20 : 13:59:56
|
| Hai EveryoneI want to import data and tables from MsAccess to Sql Server 2005. Is it possible in Sql Server 2005?If yes,Anyone, Please tell me, how to achieve that.Thanks in AdvanceSuresh Kumar |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-20 : 18:40:38
|
In SSMS right click on database in object explorer.Tasks (or all tasks) import.It comes up a wizard where you can choose input from access.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
soori457
Yak Posting Veteran
85 Posts |
Posted - 2009-06-22 : 06:04:11
|
| Hai WebfredThanks for your reply, but I did not understand that how to import the data from MsAccess.what is SSMS?can you please provide me a screen shots of how to import data from MsAccessSuresh Kumar |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-06-22 : 06:18:52
|
| try like thisright click on database go to tasks--> import data then wizard will open click next and give the details as mentioned and next import the maacess file .... |
|
|
|
soori457
Yak Posting Veteran
85 Posts |
Posted - 2009-06-22 : 06:27:43
|
| I do not found tasks option when I right clicked on database..Suresh Kumar |
|
|
|
soori457
Yak Posting Veteran
85 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-22 : 07:02:02
|
quote:
Originally posted by soori457
I do not found tasks option when I right clicked on database..Suresh Kumar
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
How to import Data from MsAccess to SQLServer 2005