Exporting data in Access fields to cells in Excel

T

TrueGAPeach

I need to export the call information in Access to an exsisting excel
spreadsheet (different one for each contact) and have it insert a row in
excel each time a new entry is completed. Basicly I have a call log in Excel
that must be updated for each contact with the call information (date, time
and notes) from Access. Is there a way to link this information without
having to copy and paste from the new spreadsheet that access creates when
moving the data?
 
P

Piet Linden

I need to export the call information in Access to an exsisting excel
spreadsheet (different one for each contact) and have it insert a row in
excel each time a new entry is completed.  Basicly I have a call log inExcel
that must be updated for each contact with the call information (date, time
and notes) from Access.  Is there a way to link this information without
having to copy and paste from the new spreadsheet that access creates when
moving the data?

why not just link to the spreadsheet and do the append/update from
Access? (Or is this one of those nice MS lawsuit problems?)
 
D

Douglas J. Steele

why not just link to the spreadsheet and do the append/update from
Access? (Or is this one of those nice MS lawsuit problems?)

Yes, due to losing the lawsuit a couple of years ago, it's no longer
possible to update linked Excel tables from Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top