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 |
|
vbuser26
Starting Member
21 Posts |
 Posted - 2007-10-18 : 22:20:38
|
| Hi sql expert,Is it possible to convert a microsoft access mdb to microsoft sql mdf? |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-18 : 22:43:59
|
No it's not possible, you need to use DTS or SSIS to migrate data from Access to SQL Server.
Future guru in the making. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-19 : 09:41:43
|
| If you're using 2000 check the Upsizing wizard in Access 2000Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
vbuser26
Starting Member
21 Posts |
Posted - 2007-10-21 : 21:40:31
|
| Hi Jackv,Is there a sample code like upsizing wizard because i need a soft copytnx. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-21 : 21:56:28
|
| It's menu option in access. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-22 : 03:19:55
|
| I think it's under Database UtilitiesJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-22 : 04:13:13
|
| " If you're using 2000 check the Upsizing wizard in Access 2000"has this "gone" in more recent versions then?Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-22 : 23:05:31
|
| Still in access2k3. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-23 : 01:53:06
|
Download the Wizard from www.microsoft.com
E 12°55'05.25"N 56°04'39.16" |
|
|
|
ishit89
Starting Member
1 Post |
Posted - 2010-02-17 : 15:46:56
|
| By Ms Sql server 2005 u can convert .mdb to .mdf1) create blank database2) Right clik to blank database Go to Task and select Importthen wizard will explain to get the data from .MDB to .MDF~ I$HIT BHATT~ I$HIT BHATT |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-18 : 03:22:45
|
| All that will get you is the tables and the data, and maybe a primary key. Or am I missing something?Indexes? Foreign Keys? Constraints? I can't see IMPORT pulling those from Access, that is what the Upsize Wizard is for |
|
|
|
|
|
|
Convert MDB to MDF