使用ms访问链接到mdf [英] Use ms access to link to 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屋！