LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
WSF WSF is offline
external usenet poster
 
Posts: 6
Default Sending data to Access MDB Table?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel VBA: sending output data table to created .csv file +append Options Mike Excel Discussion (Misc queries) 1 December 10th 11 12:39 PM
Sending Data to Access Database PattiP Excel Discussion (Misc queries) 1 December 12th 05 10:47 PM
Sending data to Access Database PattiP Excel Discussion (Misc queries) 2 December 11th 05 08:25 PM
Append Data To Access Table Martin[_14_] Excel Programming 3 December 3rd 03 08:33 AM
Export Data to Access Table Pete T[_2_] Excel Programming 1 October 10th 03 11:47 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"