Well, you can certainly write a windows script to launch ms-access...import
the data..and close it down.
It is not at all clear "where" the data is coming from, and how it is to be
loaded into ms-access.
Is the data already in ms-access mdb file format?, is it a text file?
Have you EVER done a data import into ms-access? (hint, you built a import
spec).
As a general rule, you will use the ms-access UI, but nothing is stopping
you from writing small windows scripts, or small ms-access scripts to import
the data.
The real detail missing here is where you plan to load/import this data
from, and what kind of format you are going to use, or import here?
It also not clear if you are asking about sql scripts or sql data to import?
There is no command line tool in ms-access to import, or process sql
commands. However, a simple script in ms-access can be written to process
text sql commands, or can even execute sql commands directly in the debug
window.
currentdb.Execute "delete * from tblTemp"
You would be best to just place the sql in the ms-access query bilder , and
then execute them. (but, where/when you need this to happen is not clear).
Also, it seems you are bit confused, as ms-access is not a database.
MS-access is a developers tool like VB, c++, or <insert you favorite
development system here>
ms-access makes a fine client to oracle, or sql server, or the desktop JET
engine. Sql server does not let you build a user interface like ms-access
does.
So, the idea here is that you build the application in ms-access, and CHOOSE
a database engine such as sql server, or oracle to work WITH this
application you built in ms-access.
So, keep in mind, ms-access is really like VB, or any other development
tool...it is not the data engine part...
