anand padia
Last Activity: Aug 2 '10, 03:34 PM
Joined: Jun 28 '10
Location:
-
Thanks a ton - Problem resolved -
So sorry about not explaining the request clearly, I have this tool which allows people to update there information. I cannot use access to manipulate it as not all have access available and even it would be available I do not want to give them access to master database.
We have more than 500 employee's when ever some one moves out of one role to another or when someone leaves the organization. A manager has to request for hierarchy...Leave a comment:
-
update and delete single access record set via excel vba
I have this tool where employee information needs to be updated. I call in the MDB data to excel in one sheet. Now I use vlookup to see what is there and change it if needed.
I have tried some tricks however some thing seems to be wrong.. please help.
...Code:Sub update() Dim cn As Object Dim rs As Object Dim a As String strFile = "D:\temp excel\EIM.mdb" strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data
-
Yes you are absolutely right. Do you think it can be done......Leave a comment:
-
Thanks will try that. However when in terms of going for a separate INSERT and DELETE queries I know how to do that individual, but how to compare it with existing records on excel....Leave a comment:
-
I was able to achieve little bit...
...Code:Sub UpdateMDB() Dim cn As Object Dim rs As Object strFile = Workbooks(1).FullName strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFile _ & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";" Set cn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset")Leave a comment:
-
compare excel and access table and update changes
I have a master access table where we store all the employee information. I have various application developed in excel which imports and uses information in master.
Now I want to develop a excel application that will import all the records from access table or some particular data (defined by field id) in excel spreadsheet. (***successfull y acomplished)
User would be able to view the records and make changes to the...
No activity results to display
Leave a comment: