Link 1 field in a table to a cell in Excel

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

Guest

I have a table that records employee hours worked & etc... I have an Excel
spread that records how much time an employee accrues based on their hire
date.

When someone takes 5 hours vacation (recorded in Access) can I link that
info to the Excel spreadsheet to a certain cell? I know how to import Excel
tables into Access but not the other way around. And is it possible to only
link one field in the table to one cell in the worksheet?

Thanks!
 
The general approach is to create a query in Access that returns the
value(s) you need, and then use Excel's Data|External Data menu command
to insert the results of the query into the cell(s).
 
TransferSpreadsheet allows you to specify a range. That range can be a
specific cell.
docmd.TransferSpreadsheet
acExport,acSpreadsheetTypeExcel9,"tbl_itms","c:\documents and
settings\hargida\my documents\SAP Feed Matrix August
2005.xls",false,"tblAdjustedActualsValidate!A16:A16"
 
Back
Top