• excel upload

    By connie kessler 9 years ago

    i try to update some fields in a notes form via an Excel spreadsheet. i created an Excel file with a custID (key) and some field. (e.g. firstName, lastName etc.) modifications in those fields in Excel i want to upload to notes (replace). i set up the config doc, i matched the Excel fields and the target DB fields and i entered the key. however, whenever i try Analysis mode it tells me:

    "the number of the selected fields in the source db/spreadsheet must equal the number of the selected fields in the target db"

    i could not find any further info about using DMA with Excel. any help possible? thanks