Connecting to MS Access within a .vbs script.

[Santosh]

Hi All

Just to let you know I have little programming experiece. Also Im new to
programming with Databases. I have done bits and pieces of VB System Admin
scripting and Excel automation.

My question is: Could you please tell me how to connect to MS Access
Database from a .vbs script file. I need to automate some regular tasks
which are done on a daily basis involving MS Access 2003. The only info that
I know is that there are two ways of connecting DAO and ADO. But dont know
much about how to connect or what parameters to use to connect within .vbs
file. An example would be great. My task is to connect to access, create a
table of fixed value and put some data into it.

Thanks
Santosh

 

[Aaron Kempf]

yeah of course you can do this


you'll have to use variants


Dim rst
Set rst = createobject("ADODB.Recordset")


so do I need to continue; or do you have it from there?

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Tom Wickerath]

you shoudl use ADO, kid