Importing to Access without opening it.

[sm0000]

I import text files to Access quite frequently and it is done from within access or excel using VBA.
The events are: open Access, import data, Close Access.
Instead, I would like to do the same without opening Access or Excel.
I am thinking about batch file or something less CPU demanding.
When using Excel I don't open Access but create DAO connection so why not using the same from batch?
Or maybe there is a way to execute this VBA from batch?

Any suggestions?
Sebastian

 

[FoFa]

Write a VB Script to do it using ODBC