I have an old DBF file that I want to manipulate its data directly through SQL Server Management itself, for example, perform update, insert, delete operations.
I tried using the following code from the internet results, but there is an error:
EXEC sp_configure 'show advanced options', 1 RECONFIGURE; EXEC sp_configure 'Ad Hoc Distributed Queries', 1 RECONFIGURE; GO SELECT * INTO SomeTable FROM OPENROWSET('Microsoft.ACE.OLEDB.12', 'Driver=Microsoft Visual FoxPro Driver; SourceDB=\\C:\Users\Administrator\Desktop\BIMEH\POR\DSKKAR00.dbf\; SourceType=DBF', 'SELECT * FROM DSKKAR00');
Msg 7403, Level 16, State 1, Line 10
The OLE DB provider "Microsoft.ACE.OLEDB.12" has not been registered.
Note: I just want to change this DBF file through SQL Server queries also I have Installed this : https://www.microsoft.com/en-us/download/details.aspx?id=13255