将数据复制到共享点列表时出错.参数太少.预期的1 [英] There was an error copying data to a Sharepoint List. Too few paramaters. Expected.1

问题描述

嗨

我是新手，不是程序员.

I am a newbie and not a programmer.

我正在尝试将简单的Access DB(2016)导出到SharePoint

I am trying to export a simple Access DB (2016) to SharePoint

有1个表和1个查询.

我成功导出了1张桌子

当我尝试导出1个简单查询时，出现以下错误

When I try to export the 1 simple query, I get the following error

 将数据复制到共享点列表时出错.参数太少.预期的.1

 There was an error copying data to a Sharepoint List. Too few paramaters. Expected.1

这是代码

选择[请求类型] .ID，[请求类型].[受影响的项目]，[请求类型].类别，[请求类型].关键字，[请求类型].类型，[请求类型].[受让人组]
从[请求类型]
在哪里((((([Request Types] .Keywords)类似'*'& [Enter关键词:]&"*")));

SELECT [Request Types].ID, [Request Types].[Affected Item], [Request Types].Category, [Request Types].Keywords, [Request Types].Type, [Request Types].[Assignee Group]
FROM [Request Types]
WHERE ((([Request Types].Keywords) Like "*" & [Enter Keywords:] & "*"));

基本上我想创建一个搜索查询，提示用户输入关键字，如果找到了关键字，则显示包含该关键字的所有记录.

Basically I want to create a search query where the user is prompted to enter keyword(s) and if the keyword is found, all records containing the keyword(s) are displayed.

如果删除条件，我就能导出查询.

I am able to export the query if I remove the criteria.

导出没有查询的查询后，是否可以在共享点中以某种方式构建查询?

Can I build the query somehow in sharepoint, after I export the query without it?

推荐答案

我们目前正在调查此问题，并将尽快为您提供更新.

最好的问候，

温迪

Hi,

We are currently looking into this issue and will give you an update as soon as possible.

Best Regards,

Wendy

这篇关于将数据复制到共享点列表时出错.参数太少.预期的1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！