Automatically insert data

[-Pekka-]

Hello,

Is there a way to insert data to tables automatically using like
somekind of ".bat" file?

Case is this, we have several databases, structure identical, data
varys in each. All of these databases need to have a few identical new
entrys.

Hopefully there is a solution where i don´t have to open all databases
and manually insert all tables, but to doubleclick "update.bat" (just
an example so you can get the idea) and it will do the job.

All databases are type of office97, this is because the solution which
uses database is so old . I have pc where i have installed
office97.

-Pekka-

 

[Wayne-I-M]

Hi

You don't need a bat file. Just import the tables into one DB then run an
append query to add the data to one table.