Access/Excel Communication

I'm not sure if this is the right place to post this, but here goes...
I've built a macro to format an Excel sheet of data to mirror the layout of an Access table. I'm trying to figure out a way to automate the merging/appending of the Excel data into my Access table, either from within Access, or with the macro in Excel. I'm sure there is a way to do this, and suspect it involves extensive VBA on both ends. I'm fairly good with the Access end, but still a newbie on Excel programming (can't even figure out how to permanently save the macro I built as a button, or otherwise retrieve it when I open the document). I know there are some pretty skilled folks in this forum, and am desperatly hoping to tap that talent! Please, any siggestions would be welcome. Thanks.

If you are recording the macro, make sure you save it in PERSONAL.XLS. That
way it will be available on your computer every time you start EXCEL.

"andysgirl8800" <andysgirl8800.28fd7b_1148664002.5199@excelforum-nospam.com>
wrote in message
news:andysgirl8800.28fd7b_1148664002.5199@excelforum-nospam.com...
>
> I'm not sure if this is the right place to post this, but here goes...
> I've built a macro to format an Excel sheet of data to mirror the
> layout of an Access table. I'm trying to figure out a way to automate
> the merging/appending of the Excel data into my Access table, either
> from within Access, or with the macro in Excel. I'm sure there is a
> way to do this, and suspect it involves extensive VBA on both ends.
> I'm fairly good with the Access end, but still a newbie on Excel
> programming (can't even figure out how to permanently save the macro I
> built as a button, or otherwise retrieve it when I open the document).
> I know there are some pretty skilled folks in this forum, and am
> desperatly hoping to tap that talent! Please, any siggestions would be
> welcome. Thanks.
>
>
> --
> andysgirl8800
> ------------------------------------------------------------------------
> andysgirl8800's Profile:
> http://www.excelforum.com/member.php...o&userid=34752
> View this thread: http://www.excelforum.com/showthread...hreadid=545967
>