kbsudhir
05-13-2009, 11:59 AM
Hi All,
I am using the below code to find the max value in access 2003 from excel 2003.
rs.Open "SELECT Max(A_Table.Num) AS FROM A_Table", cn, adOpenStatic, adLockOptimistic
But I am getting the below error:
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the puntuation is incorrect
Please guide.
Regards
Sudhir
I am using the below code to find the max value in access 2003 from excel 2003.
rs.Open "SELECT Max(A_Table.Num) AS FROM A_Table", cn, adOpenStatic, adLockOptimistic
But I am getting the below error:
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the puntuation is incorrect
Please guide.
Regards
Sudhir