Importing Access file to SQL Server
I am trying to get data from an Access.accdb file into SQL Server Express 2012. I see that the import options for SQL Server do not allow for an .accdb type import, so I saved the database to an .MDB format.
When I try to import to SQL Server, however, I get an error message. See attached file.
Anyone know what the problem is or how to get around it. What is the best way to import an Access.accdb file into SQL Server Express 2012?
2013-12-30-225434.jpg
When I try to import to SQL Server, however, I get an error message. See attached file.
Anyone know what the problem is or how to get around it. What is the best way to import an Access.accdb file into SQL Server Express 2012?
2013-12-30-225434.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all
ASKER
I am using Access 2013. The upsizing wizard is no longer a part of Access 2013. The SQL Server Migration Assistant does not specifically mention Windows 8 (or 8.1 - what I have) as an Acceptable OS. Will it work with Windows 8?