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-

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.


--
Wayne
Manchester, England.



"-Pekka-" wrote:

> 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-
>