View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default Append Data In Worksheet To Access Table

Exactly how many groups did you cross- and multi-post to? Did you
re-post to all these groups to say you have already received "a great
response!!!"? Apparently not.

--

"Martin" wrote in message ink.net...
Colo,

Thank you for responding!

I want each Excel user to be able to independently append data to the Access
table.

Martin


"Colo" wrote in message
...
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