Update current record in Access using Excel
Hi, the following piece of code will help you to update the name in a for a
given ID.
Const DSN As String = "ODBC;DATABASE=myDB;UID=;PWD=;DSN=DSN_TEST;"
Dim ws As DAO.Workspace
Dim con As DAO.Connection
Set ws = DAO.CreateWorkspace("", "", "", dbUseODBC)
Set con = ws.OpenConnection(DSN, dbDriverNoPrompt, False)
query = "UPDATE Map_Project_Resource SET NAME='madhan' WHERE ID='E001';"
con.Execute query
con.Close
ws.Close
"Noemi" wrote:
Hi
Would someone be able to help me with the code to use to find a record in an
access table so I can update data for that record using information in an
excel spreadsheet.
Thanks
Noemi
|