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来创建与另一个表具有完全相同结构的新表。
- I tried using this : Create new table from a query on another table in ado
- 我尝试使用它：从ado中另一个表的查询创建新表
- And this: How do you create a MS table in C# programatically
- 而且：你如何以编程方式在C＃中创建一个MS表
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;