Open Access, Paste data to table, and close all from Excel Macro

[Guest]

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.

 

[Guest]

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

 

[Guest]

Does that overwrite existing data that is in the table in the database? I
only want to add the new information to what is already there.

Thanks