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