Determining the number of Vbcomponents in an Access database remotely opened by Excel

[anichebe]

Hi all,
I have successfully used an Access database programmatically via Excel VBA. However, when I try to determine the number of VbComponents in said Access database from Excel VBA, Excel VBA returns undefined.
Any help in this matter would be greatly appreciated.


Thanks and regards


anichebe

 

[nshah1013]

Could you please tell me how did you imported data from excel to access. I am trying to do the same but i am not too good with VB. If you could please post the sample code.

Thanks