Access/Excel Communication

[andysgirl8800]

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.

 

[Barb Reinhardt]

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" <[email protected]>
wrote in message
news:[email protected]...