Search results

  1. I

    Import to access table from excell "Ignore duplicates"

    Hi guys I have code written which imports excel data to a access table but after the first import it fails due to duplicates, how can i tell it to ignore duplicates in the table and only copy new records? thanks code is below. Function SyncEmployes() Dim lngColumn As Long Dim xlx As...
  2. I

    Help Importing Excell data to Access table

    Hi All I have a VBA function to syncsuppliers as below Function SyncSuppliers() On Error GoTo errhandle Filename = DLookup("SupplierPath", "Setup", "SetupActive = True") If Filename = "" Then Exit Function End If Set xlapp = CreateObject("Excel.Application") Set xlBook =...
Back
Top Bottom