Running MS Access from VBScript

Hi there,

I have a few questions;
1) How can I start Access from vbScript?
2) Is it possible to start a macro while starting Access in order to
import a CSV-file ?
3) Do you know a site with info regarding MS Access AND VBScript?

Thanks in advance

André

Bob
Sat Aug 30 07:07:21 CDT 2003

Andre vWG wrote:
> Hi there,
>
> I have a few questions;
> 1) How can I start Access from vbScript?

There are examples for Automating Access in Access online help. They only
need a little modification to convert them to vbscript. The full answer to
this question depends on whether you are using vbs in server-side code in an
asp application, or in client-side code, or in a standalone vbs file.


> 2) Is it possible to start a macro while starting Access in order to
> import a CSV-file ?

This is an Access question that can be answered by either looking it up in
the Access Help system or asking on an Access newsgroup.

> 3) Do you know a site with info regarding MS Access AND VBScript?
>
Again, it depends on where you are using vbscript. If ASP, then
m.p.inetserver.asp.db will do. Otherwise, this is the newsgroup for you.

Bob Barrows

Bryan
Sat Aug 30 07:06:50 CDT 2003


Dim obj_AccessDB
Set obj_AccessDB = GetObject("C:\UA System Manager.mdb")
obj_AccessDB.DoCmd.RunMacro "macroTest"
Set obj_AccessDB = Nothing


"Andre vWG" <avwg@planet.nl> wrote in message
news:91083919.0308300349.2737ddea@posting.google.com...
> Hi there,
>
> I have a few questions;
> 1) How can I start Access from vbScript?
> 2) Is it possible to start a macro while starting Access in order to
> import a CSV-file ?
> 3) Do you know a site with info regarding MS Access AND VBScript?
>
> Thanks in advance
>
> André