从查询创建数据库 [英] Creating a database from a query

问题描述

你好。我正在尝试将MS Access数据库链接到SharePoint 2007网站。为此，我想将数据从SQL Server链接到MS Access数据库。我的问题是我想在查询中链接多个表。是否可以只将我的查询
链接到数据库，还是必须链接整个表？谢谢！

解决方案

你是什么意思？您的查询位于何处？听起来你在Access之外创建了查询，并且询问是否可以将Access数据库链接到它。这是正确的吗？

Hi guys. I'm trying to link a MS Access database to a SharePoint 2007 site. To do this, I want to link the data from a SQL Server to the MS Access database. My question is that I want to link multiple tables in a query. Is it possible to only link my query to the database, or do I have to link an entire table? Thanks!

解决方案

Hi,

What do you mean? Where are your queries located? It sounds to me you are creating the queries outside of Access, and you're asking if you can link your Access database to it. Is this correct?

这篇关于从查询创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！