This seems like it should be easy and I feel like I'm missing the obvious answer but I'm coming up empty. I've done a quick search here but I don't see any obvious posts on this topic. I know that FM 8.5 Advanced can import table schema from one FM database to another but can it import the schema from something like an Excel file?

The world seems to revolve around XLS files and I have a very large spreadsheet I need to do some work on. I'd like to bring it into FM but I don't want to manually create the dozens and dozens of fields (XLS columns) it will take.

Can FM import an XLS file and assume the first row is the field names. I'm assuming the fields will all be text and that's fine with me. I can adjust the field types of the few that aren't text manually afterwards.

Thanks!

David Wolfe

Indianapolis, Indiana

Edited September 27, 200619 yr by Guest

Yes, FileMaker can import Excel field names along with the data as long as the field names are in the first row. Otherwise, you will get generic field names. FileMaker will also preserve the field type from Excel. Just use the Open menu item, locate your Excel file and FileMaker will do the rest.

FileMaker can also import named ranges separately from an Excel file, if desired. This can come in handy if you have a more complex spreadsheet.

Doh! I'm such a goober. I had one thing on my mind ... Import... Import... Import. Who knew? File --> Open. Welp, I'm in business now. Thanks for the help.