Is it possible to copy an excel sheet consisting of all macros to a vb project or access database?

If you have recorded macros in Excel you can view them using the Visual Basic Editor in Excel and copy the vb code behind the macros and paste this into Excel. You can run these macros directly from Access by defining an excel object first.

Ex. - Dim gappExcel As Excel.Application
Set gappExcel = CreateObject("Excel.application")

Just place the variable in front of each new line of code from excel and it will run it from Access. Hope this helps.

self correction - meant to say copy the code from Excel to Access.