Exporting Access to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting data on a daily basis from Access to an Excel file. The
problem that I am having is that the Excel file gets rewritten every time the
export takes place. Is there a way to simply add to the excel file rather
than rewriting it? I know I can set the cell range, but I want it to
recognize that there is data in certain cells, and simply start writing to
the first empty cell. Any suggestion

Thanks
nick
 
Hi Nick,

Simply create a linked table (File|Get External Data|Link) pointing to
the Excel worksheet. Then use an append query to send the data to the
linked table.
 
John,

This is being done through a Macro. Everyday at 5Am we have a download
process that runs automatically. The function used to delete records out of
one of the tables. I've created a query that now pulls that data out of the
table instead of deleting it, and it gets placed into a temp table. The
macro then runs, and exports the data from the temp table to the excel file.
Will I still be able to do what you recomended without rewriting what I've
already done? Everything that I've done thus far works except the fact that
my excel file gets rewritten.

Thanks
Nick
 
Nick,

By the sound of it, the query you are now using to "pull that data out
of the table" is an append query (appending the data to your temp
table). Make a copy of this and modify it so it appends to the linked
table instead.
 
Back
Top