Breaking News: Grepper is joining You.com. Read the official announcement!

vba sql read row count

L R answered on September 1, 2022 Popularity 3/10 Helpfulness 1/10

answer vba sql read row count

vba sql read row count

Comment

Sub Test()
  Dim c As ADODB.Connection
  Dim rst As ADODB.Recordset
  Dim sq As String
  Dim strConnectionString As String
  Dim result As Long
  strConnectionString = "DRIVER={MySQL ODBC 5.3 Unicode Driver};UID=root;PWD=;SERVER=127.0.0.1;DATABASE=dbName;PORT=3306;"
  sq = "SELECT Count(*) As row_count FROM tableName;"
  Set c = New ADODB.Connection
  c.Open strConnectionStringstring
  Set rst = c.Execute(sq)
  result = rst!row_count
  c.Close
  'MsgBox c.Errors
  MsgBox result
End Sub

Popularity 3/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: count row sql vba

Link to this answer
Share Copy Link

Contributed on Sep 01 2022

L R

0 Answers Avg Quality 2/10

Closely Related Answers

vba sql read row count

Comment

Sub Test()
  Dim c As ADODB.Connection
  Dim rst As ADODB.Recordset
  Dim sq As String
  Dim strConnectionString As String
  Dim result As Long
  strConnectionString = "DRIVER={MySQL ODBC 5.3 Unicode Driver};UID=root;PWD=;SERVER=127.0.0.1;DATABASE=dbName;PORT=3306;"
  sq = "SELECT Count(*) As row_count FROM tableName;"
  Set c = New ADODB.Connection
  c.Open strConnectionStringstring
  Set rst = c.Execute(sq)
  result = rst!row_count
  c.Close
  'MsgBox c.Errors
  MsgBox result
End Sub

Popularity 3/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: row sql count vba

Link to this answer
Share Copy Link

Contributed on Sep 01 2022

L R

0 Answers Avg Quality 2/10

vba sql read row count

Contents

More Related Answers

vba sql read row count

Closely Related Answers

vba sql read row count

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.