| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Excel VBA: sending output data table to created .csv file +append Options | Excel Discussion (Misc queries) | |||
| Export Single Record to Append to Access Table | Excel Discussion (Misc queries) | |||
| How to Append the Data to the Master Table | Excel Worksheet Functions | |||
| Append Data In Worksheet To Access Table | Excel Programming | |||
| Excel data to an Access table | Excel Programming | |||
![Martin[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
