Exporting data in Access fields to cells in Excel

  • Thread starter Thread starter TrueGAPeach
  • Start date Start date
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?
 
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?
Click to expand...

why not just link to the spreadsheet and do the append/update from
Access? (Or is this one of those nice MS lawsuit problems?)
 
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?
Click to expand...

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

Yes, due to losing the lawsuit a couple of years ago, it's no longer
possible to update linked Excel tables from Access.
 
why not just link to the spreadsheet and do the append/update from
Access? (Or is this one of those nice MS lawsuit problems?)
Click to expand...

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