0

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');

Error :

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

Improve this question

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.