reading range n storing data in Access

hi All,

I have a non- contiguos range of around 10 columns and 30 rows.
i need to move the entire data into an Access database.
Can nybody plz provide any help on this .

You can try to use next code but you need to activare Ms DAO:

open VB Editor (Alt + F11)
choose menu Tools, then Reference and the, in the list, choose Microsoft DAO 3.xx Object Library (where xx is 51 or 6 or other)

then paste this code:

Please Login or Register  to view this content.

I hope it's what you need.

Regards,
Antonio

Thanks a ton ..!!!

Regards,
rana