There is some sample code he

http://www.erlandsendata.no/english/vba/adodao/

Paul Chan wrote:
Thank you for reading my post first.

I want to set a Marco or VB script in excel. which can
auto get the data from a sheet in excel, and auto convert
into access's database.

I feel it's very hard. hope you can help me or give me
the direction.

Thank you.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html