Subject |
Re: Adding to an existing database |
From |
Ken Mayer <dbase@nospam.goldenstag.net> |
Date |
Wed, 11 May 2022 10:38:27 -0700 |
Newsgroups |
dbase.getting-started |
On 5/11/2022 8:48 AM, Bob McKinney wrote:
> Hi All: I am well aware of populating a "database" by creating a table while a database is open. My question is, is it possible to add an existing table
> to an existing database ? All of my applications, including the tables, were created in the 2011/2013 time period using various database names. Now
> that I wish to start using 2019 I wish to have all ( 25 /30 ) my tables in one database (BSSBIZ). I know that recreating a table while the db is open will list
> the new table. Then you have to append the new table from the existing table to salvage all your data. Works but messy and time consuming.
>
> If there's a way it would certainly save a lot of time and work. Many thanks............Bob
You do know about the COPY TABLE command? It copies the table,
structure, data, mdx and dbt files to a new filename, or a new location.
If you're using database OBJECTS, there's a copyTable() method that does
the same thing. You're doing too much work here. ;)
Ken
--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
|
|