Jump to content
Sign in to follow this  
ChuckL

Simple import of xls or csv

Recommended Posts

I have an excel file with 40 some fields. I created an fm table to import the data. I made a mistake and missed creating field #3 (Vendor) when creating the table. So I added the field "Vendor" to the database and then moved it to be the 3rd field "slot" in the database. However, when I go to import the data, "Vendor" is still the last field on the target side of the import window, and thus my target and source fields don't match up correctly... they're all off by one field. And if I just try to drag the last field up to the 3rd slot, it doesn't get "inserted" there, but rather it swaps positions with the field already there, so that what was the 3rd field is now at the bottom where "Vendor" was.

There's got to be a simple way to fix this... right?

thanks.

Share this post


Link to post
Share on other sites

Once you move it to the third spot, you have to make sure it is on arranged by Custom order, or if the field names match up on both sides, you can just select arrange by matching names.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.