Hi all,

Can anybody please tell me how can I retrieve the data/records (using VBS coding) from Access database and get the retrieved-data stored into a defined variable within the VBScript?

Kindly please send me the coding.

Thanks in advance!

you use it just like in vb.

create an adodb.connection and an adodb.recordset, then connect to the db and load what you want:

Dim CN
Dim RS

Set CN = CreateObject("ADODB.Connection")
Set RS = CreateObject("ADODB.RecordSet")

CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data source=[FILENAME]" ' Replace [FILENAME] with your file name (path and all)

RS.CursorLocation = 3
RS.Open "SELECT * FROM [TABLENAME]",CN ' replace [TABLENAME] with the table name

do while RS.EOF = false
[MYVARIABLE] = RS("[FIELDNAME]") ' replace [MYVARIABLE] with your variable and [FIELDNAME] with your field name
RS.MoveNext
Loop
RS.Close

CN.Close

Set CN = nothing
Set RS = nothing

enjoy
Chi

"They mostly come at night...mostly"