Click here to Skip to main content
15,900,907 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:



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 querie


What I have tried:

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');
Posted
Updated 22-Jan-23 21:45pm

1 solution

In order to get SSMS to work with a DBF file, you would need an engine installed, an d I don't know if such exists - dBase is a very old format!

You can import DBF files to SQL server, but that isn't the same thing: your changes would affect only the imported version, it would not be reflected back into the DBF file itself.

If you need to update it and continue using the file in older apps, you probabkly want to use a different manager: dbf file management system - Google Search[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900