I have a Visual Fox Pro Database (.DCX file with associated .DBF files) that I'm trying to convert to a more useful format, such as Microsoft SQL.
我有一个Visual Fox Pro数据库(.DCX文件与相关的.DBF文件),我试图转换为更有用的格式,如Microsoft SQL。
How can I add a Visual Fox Pro database as a linked server, using Microsoft SQL Server Management Studio? The VFP database requires no login or password, as far as I can tell.
如何使用Microsoft SQL Server Management Studio将Visual Fox Pro数据库添加为链接服务器?据我所知,VFP数据库不需要登录或密码。
Thank you.
/edit: I would also be happy if I could figure out a way to access a Visual Fox Pro database through Access 2007 on Windows 7. I've installed the Visual Fox Pro OLE DB driver, and can pull tables one-at-a-time into excel, but I can't seem to use Access to access OLE DB resources.
/编辑:如果我能通过Windows 7上的Access 2007找到一种访问Visual Fox Pro数据库的方法,我也会很高兴。我已经安装了Visual Fox Pro OLE DB驱动程序,并且可以一次性提取表格-time进入excel,但我似乎无法使用Access来访问OLE DB资源。
1 个解决方案
#1
3
See: How to add a Visual FoxPro database to SQL Server as a linked server
请参阅:如何将Visual FoxPro数据库作为链接服务器添加到SQL Server
#1
3
See: How to add a Visual FoxPro database to SQL Server as a linked server
请参阅:如何将Visual FoxPro数据库作为链接服务器添加到SQL Server