Exporting access file to excel file with VBA

[Washingtons]

I'm trying to export my access database to excel without overwriting what was already on the file. My query is called Combined Data Query and I'd like it pasted on the first worksheet of an Excel file called Stoplightchart.xls Can anyone write the code for me or point me in the right direction--I have very limited knowledge of visual basic.

Thanks for your help!

 

[nightghos]

The best way to do it is to write a VBA on excel, to accesss your Access file via ODBC, and append the data at the end of you actual records, i don't have time to give a code but i have this bookmark that can be usefull for you.

http://www.exceltip.com/st/Import_d...l_(ADO)_using_VBA_in_Microsoft_Excel/427.html