将所有表从一个数据库复制到另一个数 [英] Copy all tables from one database to another

问题描述

如果我希望能够将现有数据库中的所有表格复制到名为New.mde的
来自另一个名为New.mde的数据库，请点击

在Original.mde中，有一种简单的编码方式，而不是在Original.mde中为每个表命名

。我正在寻找一种在现场更新

数据库的方法，而无需访问数据库窗口并将现有表格导入新的空数据库。


dixie

解决方案

2004年2月25日星期三15:37:43 +1100，dixie < di **** @ dogmail.com>

写道：


不知道为什么你不只是制作数据库的副本。但是，除了
之外，你可以走TableDefs集合来查找所有

表的名称。


-Tom。

如果我希望能够将现有数据库中名为Original.mde的所有表复制到另一个名为New.mde的数据库中在Original.mde中有一个简单的编码方式，没有在Original.mde中为每个表命名。我正在寻找一种在现场更新数据库的方法，而无需访问数据库窗口并将现有表格导入新的空数据库。

dixie

遍历TableDefs集合并导出每个表格......？

-

Bradley

软件开发人员 www.hrsystems.com.au

基督徒回应 www.pastornet.net.au/回复


" dixie" <二**** @ dogmail.com>在消息中写道

新闻：zF **************** @ nnrp1.ozemail.com.au ...

如果我希望能够将现有数据库中名为Original.mde的所有表复制到另一个名为New.mde的数据库，从一个按钮点击
事件在Original.mde，是否有一个简单的方法在没有命名原始代码的每个表中编码它。我正在寻找一种在现场更新数据库的方法，而无需访问数据库窗口并将现有表格导入新的空数据库。

dixie

" dixie" <二**** @ dogmail.com>在新闻中写道：zFV_b.174

If I wanted to be able to copy all of the tables in an existing database
called Original.mde to another database called New.mde from a button click
event in Original.mde, is there an easy way of coding it without naming
every single table in Original.mde. I am looking for a way of updating a
database on site without needing to access the database window and import
the existing tables into a new empty database.

dixie

解决方案

On Wed, 25 Feb 2004 15:37:43 +1100, "dixie" <di****@dogmail.com>
wrote:

Not sure why you''re not just making a copy of the database. But that
aside, you can walk the TableDefs collection to find the names of all
tables.

-Tom.

If I wanted to be able to copy all of the tables in an existing database
called Original.mde to another database called New.mde from a button click
event in Original.mde, is there an easy way of coding it without naming
every single table in Original.mde. I am looking for a way of updating a
database on site without needing to access the database window and import
the existing tables into a new empty database.

dixie

Loop through the TableDefs collection and export each table... ?
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"dixie" <di****@dogmail.com> wrote in message
news:zF****************@nnrp1.ozemail.com.au...

If I wanted to be able to copy all of the tables in an existing database
called Original.mde to another database called New.mde from a button click
event in Original.mde, is there an easy way of coding it without naming
every single table in Original.mde. I am looking for a way of updating a
database on site without needing to access the database window and import
the existing tables into a new empty database.

dixie

"dixie" <di****@dogmail.com> wrote in news:zFV_b.174

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