Hi Martin,
Please lookin to "TransferSpreadsheet" in the help of Access.
--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)
URL:
http://www.interq.or.jp/sun/puremis/...astersLink.htm
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
"Martin" wrote in message
k.net...
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