| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
Append Data In Worksheet 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 |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Append Data In Worksheet To Access Table
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 |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Append Data In Worksheet To Access Table
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 |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Append Data In Worksheet To Access Table
Here's some example code to be run from an Excel workbook, but not the
workbook you are querying to avoid the memory leak bug (MSDN Q319998). In absence of any detail, I've made inventions and assumptions e.g. MyWorksheet is arranged as a database and has two columns headed 'Col1' and 'Col2' with data below etc. Post back if you require more details. '<code--------------- Sub test1() Dim oCon As Object Dim strSql As String Set oCon = CreateObject("ADODB.Connection") oCon.Open = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=\\Server\Folder\MyDatabase.mdb" strSql = "INSERT INTO MyTable (RefID, Surname)" & _ " SELECT T1.Col1 AS RefID, T2.Col2 AS Surname" & _ " FROM [MyWorksheet$] T2 " & _ "IN 'C:\MyWorkbook.xls' 'Excel 8.0;'" oCon.Execute (strSql) oCon.Close End Sub '</code--------------- -- "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 |
|
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| 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) | |||
| append worksheet with data from another | Excel Worksheet Functions | |||
| excel worksheet export into access table | Excel Worksheet Functions | |||
| How to Append the Data to the Master Table | Excel Worksheet Functions | |||
![Martin[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
