Inner Join Openrowset in VBA for AS400

[yudia]

In MSSQL programming, there is a code : INNER JOIN OPENROWSET to join table in excel worksheet with MSSQL database.

My question is What codes in VBA Programming that have the same function as INNER JOIN OPENROWSET in MSSQL but the function is joining table in excel worksheet with AS400 database. Thanks.

[Rabbit]

Someone can correct me if I'm mistaken but I don't believe VBA has that functionality.

[NeoPa]

You aren't mistaken Rabbit.

This question was previously asked in Update table in as400 using table in excel worksheet (Post #5). The OP was advised then that the question doesn't make sense and that they need to repost it so that it does. Clearly there can be no equivalent of a SQL clause in VBA, as you'll see was explained already.

@Yudia.
Please don't make me go to the trouble of warning you for doing exactly what you were told not to do.

This thread is available for help with this problem, but you'll need to ask it in such a way as to make sense before anyone can help you. From your other thread it seems your understanding is too confused for us to help at this point. Others may better understand what you want help with, but if you want everyone to then you'll need it to make sense.

From your other thread it seems you're trying to do something that simply isn't possible. I'll be very happy to hear that is no longer the case. Simply repeating the same senseless question when you don't get the answer you want though, is not getting any of us anywhere.