Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    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.

  2. #2
    Join Date
    Sep 2003
    Cincinnati, Oh USA
    See "Import Microsoft Excel data into Microsoft Access" in Excel help files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts