Aditya Posted June 22, 2001 Posted June 22, 2001 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
neile Posted June 28, 2001 Posted June 28, 2001 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.
Recommended Posts
This topic is 8550 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now