.
So my question is...is 8-9 minutes to do 100 employee inserts reasonable or should it be taking a lot less time?
sample vba:
sInsertSQL = "INSERT INTO " & sTableName & " ( IsActive, FirstName, MiddleName, LastName, SIN, Sex, BirthDate, EmployeeAddressAddr1, EmployeeAddressCity, EmployeeAddressState, EmployeeAddressPostalCode, Phone, Notes ) " & _
"SELECT 1 AS ActiveFlag, Trim([Employees.FirstName]), Left([MiddleName],1) AS MI, Trim([Employees.LastName]) & ' ' & [OldEmployeeID] AS ModifiedLastName, Employees.SIN, IIf([Male]=True,'Male','Female') AS Sex, Employees.DOB, Employees.Address, Employees.City, Employees.State, Employees.Zip, Employees.PrimaryPhone, 'Imported ASED - ' & Now() & ' ID: ' & [DatabaseID] AS QBNotes " & _
"FROM Employees " & _
"WHERE (((Employees.qb_exported) Is Null)) "
DoCmd.SetWarnings False
DoCmd.RunSQL sInsertSQL
DoCmd.SetWarnings True