I want to fetch data from a database named review_DB in sql server and put it in an array,and then fetch some data from an opensource search engine called Solr and put the data fetched in another array.One of the columns will be an index column in both the arrays.I just want to compare the index column.Can anyone provide me a code to do that as i am a novice in VBA?
Do a search for VBA code, and not just TestPartner. I'm sure you will find something somewhere in google.
There is a fine line here. While it is understandandable that since you are a novice, you need help, it is also not standard practice for members to just outright supply code for a task that you are being paid to do.
I would try google and see what you can find, although I suspect that you will not find any code that you can lift and fit to your task. However, you may find pointers on how to write the code yourself.
Are you trying to say that the method you used to compare two index columns is proprietary?
You have to realize that ALL of us are being paid by our firms to do things like this, but we still share and help each other. If no one shared, everyone would have to rediscover every piece of code to do things.
I'm not suggesting that you share the code, but if you shared the methodology you used, that can help others who might have the same problem in the future. That is what these forums are all about.