急！！！如何在ACCESS中一次性创建十万个空记录。

[skyhorsezxy]

如何在ACCESS中一次性创建十万个空记录。朋友问的，我做不出来。请帮助一下啊。

[wxjUN]

写一个循环不可以吗?

[skyhorsezxy]

我是说只是在ACCESS中单纯属的创建一次就很多空数据的记录行不行啊。

[tanghuan]

insert into table values(null,...) 1条

insert into table select * from table; 2条
insert into table select * from table; 4条
insert into table select * from table; 8条
insert into table select * from table; 16条
insert into table select * from table; 32条
insert into table select * from table; 64条
insert into table select * from table; 128条
insert into table select * from table; 256条
insert into table select * from table; 512条
insert into table select * from table; 1024条
insert into table select * from table; 2048条
insert into table select * from table; 4096条
insert into table select * from table; 8192条
insert into table select * from table; 16384条
insert into table select * from table; 32768条
insert into table select * from table; 65536条
insert into table select * from table; 131072条
够不够，不够再执行

[skyhorsezxy]

我是说只是在ACCESS中单纯属的创建一次就很多空数据的记录行不行啊。

[szjhxu]

不行。

自己用程序来创建。