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. 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? Link to comment https://forums.phpfreaks.com/topic/51539-mysql-select-in-excel/#findComment-256655 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.