Adding SQL linked server for legacy data formats on x64 Servers

Dbf or format of Visual Fox Pro data tables recently drove me in different direction when it comes linking it with SQL Server  2008 R2 on Windows Server 2008 x64. In other words, the solution was to on Windows Server 2008 x64 install “AccessDatabaseEngine_x64.exe” which is located http://www.microsoft.com/download/en/details.aspx?id=13255.

Use ODBC to create dbase source, add it in linked server using sp_addlinkedserver ‘nameOfLinkedServer’, ”,’MSDASQL’,’nameOfOdbc’.

Now, just type in OPENQUERY command and then you are set to go.