Exporting Data from access and appending to an existing excel sprd

[kejo41]

I run a series of queries each month in an access form that I have created. I
can export the data into a new excel spreadsheet no problem. I am just
wondering whether or not there is a way to export the data into an existing
excel file and append it to the bottom of data that has been exported in
previous months. It's not really critical, I'm just trying to make things
that much easier.

Thanks.

 

[Tom Wickerath]

You can always use the drag and drop technique. Open the Excel file to the
desired worksheet, then minimize it to your task bar. Drag a saved query from
your database to the minimized Excel task bar icon, keeping your left mouse
button held down. Wait for Excel to grab focus. Aim carefully within the
worksheet, because when you let your mouse up, the data from your query will
get pasted starting in whatever cell you aim for.

That's the very simple code-free technique.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[GBA]

another approach: import that excel - - do the append in a table inside
Access - then export the excel....

 

[kejo41]

Thanks