3 Replies Latest reply on Jun 8, 2012 12:38 AM by Sorbsbuster

    Setting fields when importing Excel file

    vmtc

      Title

      Setting fields when importing Excel file

      Post

      Hi,

      Is it possible to have a specific auto entry on some fields during an import? I get Excel Sales reports from different distributors, and when I import the file, I'd like to specify values for fields that show the distributor and the month of the report. Up til now I've been adding this manually to the Excel sheet before import, or doing a replace after, or, more dangerously, changing the auto entry for the field for a particular import. It seems to me there should be a better way than any of these, but I can't see what it is. Any help would be appreciated.

      I'm using FM Pro Adv 11.

      Thanks