Access vba code to Export tbl data to Excel spreadsheet?

[ckeola]

I am at my ropes end with this... I am very new to vba.



I have a db with a tbl and a form.
I have an Excel Workbook with multiple spreadsheets.
In a spicific spreadsheet I add data to the bottom of a long list of data.
That data starts in Column A and goes through Column T.
Every Row is a Single record(Company name, title, phone number, etc.)

spreadsheet format:

record ID	first name	last name	title	company	address	and so on
84395	John	Smith	President	Random Inc.	555 Main St	yes

NOTE: the record ID's will already exist before the data gets to me, and will need to stay the same.

The db that I am using: "my_db"
The tbl in "my_db" is: "my_tbl"
The already existing Excel Workbook: "my_excel"
The spreadsheet to be used in "my_excel" is: "my_spreadsheet"


I want to:
push a button on my form and the following happens...
- all the data in "my_tbl" is selected and copied(but NOT the headers)

- paste copied data(something comparable to paste special/CSV) into the first empty cell of Column A in "my_spreadsheet". [The Columns in "my_spreadsheet" have formulas and formatting that should not be altered]

- I do not want "my_excel" to be closed after this operation.

NOTE: "my_excel" will already be open, but minimized.


I have tried and tried... now I just want to put in the code so that I can shave minutes off of this task, which I do all day.

Please help.

[ajetrumpet]

I believe the TRANSFERSPREADSHEET method automatically pastes data below the end of the data if you transfer it to an existing spreadhsheet but I could be wrong. been a while since i've used it. If all else fails. you can simply open the book and loop the access table to write the data line by line