I do not know how to control Access via Excel. I usually just pushed my data
into an excel sheet and run the following macro in Access.

Sub tr9418()
DoCmd.TransferSpreadsheet acImport, , "tr9418",
"c:\feb2006\test4access.xls", True

End Sub

"learningaccess" wrote:

I have a macro that i have written to pull information in and format it from
a .txt file. I want to add code to the existing macro that will open an
existing Access database, open a table within that database, and paste the
data that has been copied from the excel file.

I have been searching but there is so much information to sift through it is
a little cumbersome. Any help would be greatly appreciated.