Search results

  1. I

    Import to access table from excell "Ignore duplicates"

    Thanks guys, getting an error on the dcount. If DCount("*", "Employees, "ID=" & xlc.value) > 0 Then expected list separator or ) on ID
  2. 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...
  3. I

    Help Importing Excell data to Access table

    Hi sorry new to forum. 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 = xlapp.Workbooks.Open(Filename) Set xlsheet...
  4. 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