Just expand the Linked Server and then now created Linked server, after expanding the Default you will see Tables and Views.Expand the Tables node to see a list of table objects for the folder.This page list some of the wrappers currently available. Please keep in mind that most of these wrappers are not officially supported by the Postgre SQL Global Development Group (PGDG) and that some of these projects are still in Beta version. Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store.
Later Microsoft released upgrades to MDAC as web-based redistributable packages.Data in an Excel workbook can come from two different locations.The data may be stored directly in the workbook, or it may be stored in an external data source, such as a text file, a database, or an Online Analytical Processing (OLAP) cube.Eventually, later versions were integrated with Microsoft Windows and Internet Explorer, and in MDAC 2.8 SP1 they ceased offering MDAC as a redistributable package.Throughout its history, MDAC has been the subject of several security flaws, which led to attacks such as an escalated privileges attack, although the vulnerabilities were generally fixed in later versions and fairly promptly.This external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in, and access the external data source.The main benefit of connecting to external data is that you can periodically analyze this data without repeatedly copying the data, which is an operation that can be time-consuming and error-prone.The current version is 2.8 service pack 1, but the product has had many different versions and many of its components have been deprecated and replaced by newer Microsoft technologies. The latest version of MDAC (2.8) consists of several interacting components, all of which are Windows specific except for ODBC (which is available on several platforms).Please remedy this by editing this article to remove any non-free copyrighted content and attributing free content correctly, or flagging the content for deletion.If the data source is a database, make sure that the database is not opened in exclusive mode.If the data source is a text file or a spreadsheet, make sure that another user does not have it open for exclusive access.Now you can query the DBF files just like any other table from management studio.Now open the new query window to write a query on DBF files.Then under Server Type, choose the “Other Data Source” Radio button.