如何复制MS Access数据库表？ [英] How Do I Copy an MS Access Database Table?

问题描述

我正在使用Visual Studio 2013和VB.Net。我正在寻找示例VB.Net代码将Access数据库表（仅结构 - 无数据）复制到同一数据库中，但使用表的新名称。我无法找到适当的VB.Net代码的例子来实现这一目标。提前感谢您提供的任何帮助。

I am using Visual Studio 2013 and VB.Net. I am looking for sample VB.Net code to copy an Access database Table (structure only - no data) into the same database but with a new name for the Table. I have not been able to find an example of the proper VB.Net code to accomplish this. Thank you in advance for any help you may be able to offer.

推荐答案

SELECT INTO语句是否有效？我知道它与SQL服务器有关。

例如 SELECT * INTO newtable FROM oldtable WHERE 0 = 1

Will a SELECT INTO statement work? I know it does with SQL server.
For example SELECT * INTO newtable FROM oldtable WHERE 0=1

这篇关于如何复制MS Access数据库表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！