How do you use MS Access as an object and fetch the values from MS Access database like an excel sheet?

Interview Candidate
May 9th, 2007
1
1793

Showing Answers 1 - 1 of 1 Answers

adisgee
Profile Answers by adisgee

Aug 2nd, 2007

this should help:

' -----------------------------------------------------------------
Set dbConn = CreateObject("ADODB.Coonection")
dbConn.Open("DSN=MyDatabase")

sqlQuery = "Select * From Main_Table"

Set rsRecSet = dbConn.Execute(sqlQuery)

rsRecSet.MoveFirst

Do Until rsRecSet.EOF
   varColumn1 = rsRecSet("Coulmn1").Value
   ...
   ...
   ...
Loop

Set dbConn = Nothing
' -----------------------------------------------------------------

Set the DSN using the ODBC administrator from Control panel -> Admistrative Tools.

Thanks,
Aditya.