Windows Server 2012 R2
SQL server 2012
We are moving our data systems from SQL 2008 to 2012. In Sql 2008 (on Windows 2008) I import:
- .dbf IV files using the Visual FoxPro driver
- Access 2007 files using the Microsoft Office 12.0 Access Database OLE DB Provider
Testing on the new Sql Server 2012 I do not see either of these 2 drivers in the Data Source list (Import wizard).
On our Windows 2012 R2 server, I downloaded the Visual FoxPro driver and installed it. I can now see it on the list, but as soon as I choose "Properties", the wizard crashes and asks to be closed
For Access, I downloaded and installed the AccessDatabaseEngine driver for both 2007 and 2010 (32 bit). The install seemed to go fine and I see both in "Add Remove programs", but I DO NOT see it in the SQL Server Data Source list (Import wizard).
HELP! As I understand, if I can get the "Microsoft Office 12.0 Access Database OLE DB Provider" to show properly, I might be able to import both my Access 2007 tables AND my dBase 4 files. Why can't I see it on my Import wizard Data Source list?