Hello.<BR>I have a little problem.<BR>I&#039;m updating Access table from Excel file. My code right now takes all info from Excel file and inserts it into my Access table. Here it is:<BR><BR>Dim StartRow As Long<BR>Dim EndRow As Long<BR>Dim iRow As Long<BR>Dim iCol As Integer<BR><BR>StartRow = 2 <BR>EndRow = ActiveWorkbook.Worksheets(1).UsedRange.Rows.Count< BR><BR>For iRow = StartRow To EndRow<BR> <BR> rs.addnew<BR><BR> For iCol = 0 To rs.Fields.Count - 1<BR> rs(iCol) = Cells(iRow, iCol + 1)<BR> Next iCol<BR><BR> rs.Update<BR><BR>Next iRow<BR><BR>What I want is just to insert new records. For example:<BR>if already had John Smith in my Excel file and I added Joe Doe, I only want Joe Doe to go to my Access table, not John Smith (because it is already there).<BR><BR>Any ideas ?<BR>Thanks.