I have searched and searched and I'm still unable to find the right answer.
I would like to export a table I have created in Access ("tbl_1974") to an existing worksheet (Named "1974"") in an existing workbook ("Scores")
The data would naturally paste from A1 and take up 6 columns. The reason I want to use an existing worksheet is that the sheets already have prepared formulas
from Column J on wards. Those formulas are just waiting for the data to be entered.
I have many years to do, so I am hoping that this is possible.
I tried the following code but that just created a new worksheet with "_1974" as the title
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "1974", "C:\Documents\LADDERS SORTED\scores.xlsm", True, "1974"