Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Automatically insert data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
-Pekka- - 14 Jan 2008 09:58 GMT
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 - 14 Jan 2008 10:45 GMT
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.

Signature

Wayne
Manchester, England.

> Hello,
>
[quoted text clipped - 14 lines]
>
> -Pekka-
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.