# Re: 一个资料库查询的问题

Posted by 柏先生 on April 08, 1999 at 16:32:37:

In Reply to: 一个资料库查询的问题 posted by 林文芳 on April 08, 1999 at 15:54:19:

: 我用下列方法将所Select到的资料另存到一个新的Table时:
: Data1.RecordSource = "Select * into [备份] from [测试] where [AAA] < 10 "
: Data1.Refresh
: 就会出现:执行期错误'3219':无效的操作
: 想请问该如何解决呢???

修改为：
Data1.RecordSource = "Insert into [备份] (Select * from [测试] where [AAA] < 10 )"
Data1.Refresh

试一试

Follow Ups:

- 还是不行ㄟ,出现语法错误ㄟ...(无内文) 林文芳 19:18:45 4/08/99 (1)
  - Re: 还是不行ㄟ,出现语法错误ㄟ...(无内文) AndyLin 21:29:10 4/08/99 (0)