VBA SQL Loop using QODBC
- by Dan
I am trying to loop through an existing table (tblSalesOrder) and I need to run through every line (where they relate to that particular customer) and write each line into an SQL statement and execute it.
What is the easiest way to go about this procedure?
The number of lines will need to be counted prior to data being written via SQL to a QuickBooks database.
I can code something similar in php using the code below, but I am unsure how to convert this into a VBA friendly format:
$sql_count = "SELECT count(*) FROM tblSalesOrder WHERE Customer='cust_number'";
execute_query($sql_count)
When the above value is greater than 0, the vba code should loop through the queries.
Thanks everyone
