如何使用ADO对Access数据库运行make table查询?

时间:2022-03-16 15:41:19

I've got a legacy program, and I'm working with Access 97. I want to use ADO to make new table that has the exact same structure as another table.

我有一个遗留程序,我正在使用Access 97.我想使用ADO来创建与另一个表具有完全相同结构的新表。

This is what I'm getting:

这就是我得到的:

 Select * FROM [TempMergeTable] INTO [TempMergeTableFix]
 Syntax error in FROM clause

TempMergeTableFix doesn't exist already. Will this not work with Access 97?

TempMergeTableFix已不存在。这不适用于Access 97吗?

What's going on and how can I do this?

发生了什么事,我该怎么做?

1 个解决方案

#1


0  

Oh, it was a syntax error after all. It really should have been:

哦,毕竟这是一个语法错误。它应该是:

SELECT * INTO newtable FROM source;

#1


0  

Oh, it was a syntax error after all. It really should have been:

哦,毕竟这是一个语法错误。它应该是:

SELECT * INTO newtable FROM source;