I have an Access database from Access 2010. I know this creates .accdb files, NOT .mdb files. I am trying to import data from the access database into sql server 2008 R2. I installed this:
Microsoft Office 12.0 Access Database Engine Provider
Problem is, it doesn't work. If I select it in the import wizard, it errors out and sql server closes. There were no problems during the installation problem, and there was a message saying the installation had completed successfully.
I did try rebooting the computer and trying it again. Nothing has worked.
How can I import new format access data into sql server?