Access to Excel

  • Thread starter Thread starter Qaspec
  • Start date Start date
Q

Qaspec

I posted this message in forms programming but I guess
this is the correct place for this question.

How do i create a function that will allow me to place the
results of a query into an excel file? The result of the
Query will always be one record long and have 4 columns
("Name" "Score" "Ratio" "Performed"). When I click a
command button I need the excel file to open with the data
for Name placed in cell A4 ,Score in B4, Ratio in C4 and
Performed in D4. The Excel file is DailyRep.xls and the
sheet is Sheet1.
Your help is appreciated.

Qaspec
 
Hi Qaspec,

You can do this by using Automation. The following links show the basic
techniques:

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859
 
Back
Top