Robin,
You can do it the other way and link your Access DB to the Excel file.

NickHK

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

Many thanks