如何在ms访问的特定列中插入 [英] How to insert in specific column of ms access

问题描述

我有一个包含30个字段的Ms Access 2010表...

但是我想插入一些选定的字段...不是全部...

假设我想仅将记录插入20-35列..

我要做的事情......我尝试了一些代码......但没有成功......请帮助

请帮助...

I have a Ms Access 2010 Table with 30 fields...
But I want to insert into some selected fields... not all...
suppose I want to insert record into 20-35 column only..
what I have to do.... I tried some code.. but no success... please help
please help...

推荐答案

按建议添加为解决方案。



在您的插入语句只指定要插入的列数。你没有插入数据到每一列。



下面是伪代码，它会给你一个想法。它直接取自MSDN

Added as a solution as suggested.

In your insert statement just specify the number of columns you want to insert. You don't have insert data into every column.

Below is pseudo code that will give you an idea. It is taken directly from MSDN

INSERT INTO target [(field1[, field2[, …]])] VALUES (value1[, value2[, …])

这篇关于如何在ms访问的特定列中插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！