Hi All,

I am facing a problem with the importing order. I created a FM file where I want to import the data from another excel file on a regular basis. The probelm started with as I missed one field to define in filemaker table matching with the excel file so i created new field and moved to the desired location in "define field" . Now whenever I try importing the data, the new field is always in last and I can not correct the problem using the "view by". I can not use the matching names as the excel table contains data only and no field.

any help will be appreciated.

Thanks

Aditya

Import the excel data correctly: You can move the filemaker fields to the correct position on the right hand pane of the Import Field Mapping window. Just click on the field name and drag it up or down.

When the import is complete, create a script with the 'import records' step, and make sure 'Restore import order' is checked.

If the excel file always has the same name, select it from the 'pecify file...' button, and check the 'Perform without dialog' box.