Originally posted by Steve Gao:
Hi everyone!
I tried many methods to get the defination of the queries of MS Access. But no result could be returned. First, I used ODBC and DatabaseMetaData interface to try. Secondly, downloaded jdbc from Microsoft. No use. Help! I need convert these queries to stored procedures of MS Sql server. Who can help me? Thanks a lot.
I cannot understand your problem. Are you trying to use stored procedures using MS Excel as the database ? If you are trying this. I had the same problem when using callable statements. I figure the format is different.
Try using SQLServer as it works well. If you need help in this I will send out an example during the weekend. Do reply.