Insert Data into an Excel worksheet

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

I have an Access query and an Excel file. I want to export
the results of the Access query to the Excel file the way
that the query results are added to the Excel file(I don't
want to overwrite the data in the excel file). In another
word, I want the data in the Excel file to be accumulative.
Can someone tells me what's the code to accomplish this.
Please be specific in terms of the code's syntax and scope.
Thanks,
 
Why not Link to the Excel file and run an append query to
add the new records/rows.

Jim
 
Thanks. I agree with what you said, but how to make Access
data available in Excel? I need to know the code for that
and I need to know if I shall write this code in Access or
Excel. Please advise
 
I am not sure I understand you. If you link an Excel
worksheet and append the data to the linked table you are
inserting the data directly into the workbook. It is
avialable for anyone.

To link and excel worksheet
File/Get External Data/Link
Change file type to Excel
follow steps
The Excel sheet appears as a linked table

You can now write an append query to add data to that
linked table.

Jim
 
Back
Top