使用ms访问链接到mdf [英] Use ms access to link to mdf
本文介绍了使用ms访问链接到mdf的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个从sql server数据库中提取的mdf文件&复制到我当地的硬盘。
我尝试过:
我试图通过ms访问来访问/链接到mdf文件中的数据。 mdf文件包含1380万条记录&是一个3.5演出大小
喊删除 - Maciej Los [/ EDIT]
I have a mdf file that was extracted from a sql server database & is copied to my local hard drive.
What I have tried:
I trying to access/link to the data in the mdf file via ms access. The mdf file contains 13.8 million records & is 3.5 gig in size
Shout removed - Maciej Los[/EDIT]
推荐答案
据我所知,没有直接的方法可以将数据从mdf文件连接/导入MS Access数据库。
NotPolitcallyCorrect [ ^ ]已在评论中发布了问题a 链接到文章 [ ^ ]。该文章的作者建议将mdf文件附加到MS SQL Server实例,然后将其转换为MS Access数据库。
另一种资源:将sql server数据库转换为ms访问的简单步骤 [ ^ ]
As per my knowledge, there's no direct way to connect/import data from mdf file into MS Access database.
NotPolitcallyCorrect[^] has posted in the comment to the question a link to the article[^]. An author of that article suggest to attach mdf file to MS SQL Server instance and then to convert it into MS Access database.
Another resource: Simple steps to convert sql server database to ms access[^]
这篇关于使用ms访问链接到mdf的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文