Import overwrite tables

[AndyShuter]

Is there a way I can put a command button on that will allow me to imort tables from another database and automatically overwrite the existing tables?

Also, would the relationships and indexes be imported as well?
Many Thanks in advance

Andy

 

[namliam]

Is there a way I can put a command button on that will allow me to imort tables from another database and automatically overwrite the existing tables?​

Overwrite.. No, but you can code delete and import which does the same but problems with relationsships

Also, would the relationships and indexes be imported as well?​

No on relationships, Yes on indexes

Best way to go? => Use a BE DB that you can compact, delete the DATA in the tables, compact the DB & import the new data...

BR

The Mailman