Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Australia
    Posts
    4

    Unanswered: Error importing with TransferSpreadsheet Function

    Hi

    I have created a Macro using the TransferSpreadSheet Function.

    It brings up an error message

    http://www.matthewscomputerguide.com...rorMessage.jpg

    My Table that I am trying to import the data into you can view here

    http://www.matthewscomputerguide.com...ableDesign.GIF

    As you can see the ProductCode Field is the Primary Key.

    Also the ProductCode & VendorCode Field have the setting of No Duplicates allowed.

    As what I want is when I import the data is it updates, deletes, adds the records that are in the database table with the newer imported data, without duplicating all the records when I import.

    Can people advise on whats the best way to do this.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    The error says that you have duplicate data in one of the two fields that do not allow duplicates.

    I would import the entire spreadsheet to a table with not restrictions, then run a query to delete the duplicates.

    It seems odd to have No Duplicates on a Vendor ID field in what appears to be a product table. What if one vendor can supply two products?
    Inspiration Through Fermentation

Posting Permissions

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