Reading a Microsoft Access File

[vikramaditya234]

Hi,
I have a Access mdb file. I want to read it and gather the data from it. How can I do that? I dont have any IDE and I am using notepad to write the code. I want to use VB Script, if it possible with it, else suggest me.

[SharpDeveloper]

Hello
You can use VBScript with ASP or only VBScript
Use following steps

'Declare Variables
Dim rs, conn, DatabaseLocation

'Get the location of your Access Database
DatabaseLocation = Server.MapPath("Employee.mdb")

'Create a ADO Connection Object
SET conn=Server.CreateObject("ADODB.Connection")

'Assign the Provider
conn.Provider="Microsoft.Jet.OLEDB.4.0"

'Open the connection
conn.Open DatabaseLocation

'Open the RecordSet using ADO Recordset Object
SET rs = Server.CreateObject("ADODB.Recordset")

'Query the table in the database
sql = "Select * from Resources"

'Open the result set
rs.Open sql, conn

c=0
do while not rs.eof
c=c+1
document.write rs("EmployeeName")
rs.movenext
loop

Set rs = nothing
conn.close

Hope this helps!

Hi,
I have a Access mdb file. I want to read it and gather the data from it. How can I do that? I dont have any IDE and I am using notepad to write the code. I want to use VB Script, if it possible with it, else suggest me.

[Plater]

This really seems like it falls more under the the regular VB rather then VB.NET since you wish to use VBScript.

I will move it there.

MODERATOR