Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 8.0
I would like to be able to send data from within an Excel function to an Access log. e.g. UserName ' Network Log-in Username - I presume I can use the same code to obtain this as I use in Access? Date and Time ' the current Date and Time ReportType ' a short text string The Access MDB is named "Reports.mdb" - the Path would be to a network destination e.g. "\\server1\Reports\Reports.mdb" The table in Reports.mdb is named "tblLog", with the field names "User", "DateTime", "ReportType" The transaction would need to be discreet, in that it can occur in the background without user intervention - a weekly event that's all. Is this possible? Any help gratefully appreciated WSF |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Excel VBA: sending output data table to created .csv file +append Options | Excel Discussion (Misc queries) | |||
Sending Data to Access Database | Excel Discussion (Misc queries) | |||
Sending data to Access Database | Excel Discussion (Misc queries) | |||
Append Data To Access Table | Excel Programming | |||
Export Data to Access Table | Excel Programming |