I have checked the forum for some examples of using the CopyFromRecordset method, however I am still not certain how to implement it, so I built a test database w/the hopes that one of you folks could display the code for it -- as well as comments of what the code is doing.
I'd like to transfer the data from my query (Access 2002) into an existing / formatted excel spreadsheet (Excel 2002) -- here is what I have:
SELECT tblTEST.Name, tblTEST.Address, tblTEST.Zip
frmTEST (with command button -- cmdTEST)
An Excel spreadsheet:
Location: C:\Documents and Settings\3765\Desktop\TEST.xls
The spreadsheet contains 1 worksheet named "Sheet1"
Cell A3 contains "Name" (width 25)
Cell B3 contains "Address" (width 50)
Cell C3 contains "Zip" (width 10)
So the data would begin at cell A4...