View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ayaz Zanzeria Ayaz Zanzeria is offline
external usenet poster
 
Posts: 1
Default how do i write records in access from excel vb code?

I have designed a reports dashboard using excel vba. I want to track the
number of times this dashboard along with the report name which has been
accessed. I have created a database in access with the following fields:
Access_Date: Date/Time
Access_Time: Date/Time
User_Name: Text
Computer_Name: Text
Report_Accessed: Text
Please help with sample code in excel vb that will work in excel 2003.
Thanks in advance.