Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import Access 2010 db to SQL Server Expand / Collapse
Author
Message
Posted Thursday, March 14, 2013 11:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 01, 2013 11:59 AM
Points: 38, Visits: 89
I am trying to import a .accdb file into SQL Server but do not see any option in SQL Server Import Wizard. There is an option of importing a .mdb file but not .accdb file.

Does anyone know how to import such a file to SQL 2008?

Thanks
KK
Post #1431159
Posted Thursday, March 14, 2013 12:12 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, April 21, 2014 7:46 PM
Points: 3,738, Visits: 7,081
Under Choose Data Source, use Microsoft Office 12.0 Access Database Engine OLE DB Provider - "Microsoft Access" is for Office versions lower than 2007

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1431183
Posted Thursday, March 14, 2013 12:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 01, 2013 11:59 AM
Points: 38, Visits: 89
Yes, that worked. Thanks!
Post #1431188
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse