Check out Mr. Erlandsen's site for sample code:
http://www.erlandsendata.no/english/vba/adodao/

--
Regards,
Tom Ogilvy


"Robin Jootun" wrote in message
...
Help!
How can I transfer data from an Excel Spreadsheet to an
Access database using Excel VBA.

Many thanks