View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin[_14_] Martin[_14_] is offline
external usenet poster
 
Posts: 4
Default Append Data To Access Table

There is an Access table on the network. 15 users who do not have Access are
connected to the network. Is there a way for each user to be able to enter one
or more rows containing 3 or 4 columns to Excel on his machine and then press a
button or something and append that data to the Access table on the network?
Also would need to delete the data from the worksheet after the append. How
would I prevent more than one user from appending data at the same time? Any
suggestions on what the code would be?

Thank you very much!

Martin