davidspeare Posted May 15, 2007 Share Posted May 15, 2007 Does anyone see why I am getting an error message with the below select statement? I am using Excel VBA to connect to a web server. I'm getting an error that the ODBC driver does not support the properties. rs.Open "(SELECT [*] from [movie] WHERE [movie_year] like ['2000'])", cn, adOpenKeyset, adLockOptimistic, adCmdTable Thanks for the assistance. Quote Link to comment https://forums.phpfreaks.com/topic/51539-mysql-select-in-excel/ Share on other sites More sharing options...
fenway Posted May 18, 2007 Share Posted May 18, 2007 Are you sure the square brackets are syntactially correct? Quote Link to comment https://forums.phpfreaks.com/topic/51539-mysql-select-in-excel/#findComment-256655 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.