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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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