Jump to content
Sign in to follow this  
Sean Larkin

Can FM Automatically Define Fields Excel Import

Recommended Posts

I have an Excel spreadsheet that has 186 fields (columns). I need to make it into a FM database (i'm using 5.5v2), I have searched this forum and the manuals, but cannot find a definitive answer as to whether or not FM can automatically define fields on an import from an Excel spreadsheet based on the sheet's header row.

The closest thing I've found so far, is how to import a spreadsheet and have FM create field definitions F1, F2,.... etc, but that doesn't really solve my problem, because I'd still have to go in and rename the definitions anyway.

I hope this isn't a redundant topic that I'm bringing up. I did a search but couldn't find anything. Thanks for any help.

-Sean

Share this post


Link to post
Share on other sites

Have you tried just opening it up with FIleMaker.

You should get a little box asking if the first row is field names, answer yes.

All fields will be text so you will have to modify the dates and do any calculations within FileMaker.

HTH

cool.gif

lee

Share this post


Link to post
Share on other sites

Forgot to mention:

If I remember right, I think that it will shorten field names that are over a certain number of characters, sorry I don't remember that number.

wink.gif

Share this post


Link to post
Share on other sites

filed names are cut off after 60 characters

fieldnames beginning with numbers, conflicting fiednames and those with some keywords are preceeded by an underscore( _ ) character. FileMaker tries to guess the field type /Text,num,date,time) based on first row of data.

Share this post


Link to post
Share on other sites

Hi Christian,

Thanks for the additional information.

Hummmmm, I have never notice it gussing anything other than text. Now that I know that it should be doing this, I will pay more attention to the data to find out why it isn't doing it when it should.

Thanks again,

Lee

smile.gif

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.