Hi,
First of all I want to thank you all for being this forum.
It helps me a great deal in my first steps into VBA.
Right now I am looking for a way to update a record in a table with information, read from Excel, if the record already exists. If not, it is an append.
How could I do this?
Currently I use this:
But I want to be able to recognise if the contact is already there, so I will only update the information. The contact number is stored in a variable, so if I would be able to query the contact list with the variable, I would have the record to update (or have none).
How do I do this and go from there?
Any help would be greatly appreciated, thanks
First of all I want to thank you all for being this forum.
It helps me a great deal in my first steps into VBA.
Right now I am looking for a way to update a record in a table with information, read from Excel, if the record already exists. If not, it is an append.
How could I do this?
Currently I use this:
Code:
'Import or update the dealer file
DoCmd.TransferSpreadsheet acImport, , _
"DealerContacts", strPath & strFileList(intFile), True, "contact!A1:F2"How do I do this and go from there?
Any help would be greatly appreciated, thanks
