Appending an Access Table to an excel sheet

[teabags]

How would I go about appending an access table to a sheet in Excel. My sheet in excel has a header that i want to keep. I want to import the access table under the header.

 

[mhartman]

Hello:

What I would do is import your spread sheet to Access and append your data there and then send the completed table back to Excel.

Regards
Mark

 

[Pat Hartman]

The TransferSpreadsheet Method/Action does not allow you to specify a destination range for your data. To do this, you would need to write VBA to automate Excel and transfer the data row by row. I don't have example code, you might be able to find something in Excel Help or in the MSDN library.

 

[teabags]

Thanks for the help