Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Private Sub get_data(ByVal str_res As String, ByVal int_row As Integer) Dim obj_rs As New ADODB.Recordset Dim str_sql As String Dim str_conn As String Dim obj_conn As New ADODB.Connection str_sql = "SELECT * FROM tbl_adm_stats" str_conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str_filename & ";" obj_conn.ConnectionTimeout = 0 obj_conn.Open str_conn obj_rs.CursorLocation = adUseClient obj_rs.Open str_sql, obj_conn, adOpenDynamic, adLockOptimistic, adCmdTableDirect Worksheets(1).Cells(int_row, 1).CopyFromRecordset obj_rs obj_rs.Close obj_conn.Close Set obj_rs = Nothing Set obj_conn = Nothing End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.