Unanswered: paste append from excel to access - pls help
OK, I'm a little new at the DB side VB and I need help making a simple script.
I have an excel spreadsheet that uploads to an access front end of a SQL server.
I have 2 tables: [items] (which is single column where every item is a primary key), and a second called [requests] (primary key is autonumbered)
I need a script that will allow me to upload a column from excel to [items], but ignore the duplicates. I know a paste append function works, but I don't know how to write script for it. I've been using the ADOVB library but I only know how to add lines, not search if a line is duplicated. Any advise is greatly appreciated.