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 |
|
Wilco
Starting Member
9 Posts |
 Posted - 2007-09-17 : 18:50:09
|
| Does anyone know of a simple free export tool that will allow me to dump an Access .mdb file to SQL? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-17 : 18:53:36
|
| Try DTS Import Export wizard in SQL Server.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-17 : 20:06:34
|
quote:
Originally posted by Wilco
Does anyone know of a simple free export tool that will allow me to dump an Access .mdb file to SQL?
Or similarly SSIS to import from Access in 2005.
Future guru in the making. |
|
|
|
Wilco
Starting Member
9 Posts |
Posted - 2007-09-17 : 20:53:51
|
| What about dumping .mdb files as plain text INSERT queries? |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-17 : 21:06:40
|
quote:
Originally posted by Wilco
What about dumping .mdb files as plain text INSERT queries?
Not quite, but you may be interested in using the upsize wizard in Access as outlined here:http://support.microsoft.com/kb/325017
Future guru in the making. |
|
|
|
|
|
|
Export Tool