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

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.

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

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.

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

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

"fugazi48" wrote:

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.