How to import ".mdb" files into SQL Server 2008? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

How to import ".mdb" files into SQL Server 2008?

Author

Topic

BobLewiston
Starting Member

29 Posts

Posted - 2009-03-13 : 00:59:53

Assuming it can be done (as I've been told):

How do I import ".mdb" (MS Access / OleDb) files (specifically, Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)?

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 01:18:44

Try: http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx... should work with 2008 too .. it was the best tool I used for upgrading Access DB to SQL Server DB :).

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

BobLewiston
Starting Member

29 Posts

Posted - 2009-03-14 : 00:00:34

guptam:

Sorry, the link you gave me is no longer valid.

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-14 : 02:20:56

is vaalid :P just take out the stupid "..." i put in LOL. grr I got to stop doing stupid stuff like that ;-).

try: http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

rico1931
Starting Member

37 Posts

Posted - 2009-04-09 : 14:23:57

I found it easier just stopping the sql database copy, restart, past into new server and attach the copy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources