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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-12-29 : 08:27:31
|
| Dear All,I have an mdb file with system don't have access installed on it.I need to import access mdb database to SQL server.Can somebody tell me the easiest way to do this ?? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-29 : 09:13:36
|
| Use SSIS, or Data Import Wizard |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-29 : 09:19:04
|
| the import wizard has an access option where you can select the database file.right click on a database in management stuido and go to Tasks -> Import Data....Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Access DB import to SQL