Exporting Excel Variables/Values?

[jwm]

Hi,

I am new to FM as well as the forum. I searched and could not find an answer to my question. I am trying to find out if there is a way to export Excel (column) names and values to a FM 8 database that has defined names identical to the ones on the Excel spreadsheet, but not necessarily ordered the same way. What I am looking is possibly populating a defined database structure by name. Only a subset of the names in the database would come from the spreadsheet.

Thanks,

JWM

[marge2007]

I am also new to FM but I did export from XLS to a pre-defined database in FMP. You export data from XLS in comma delimited form and then import it into a pre-defined FMP data base. Set up your database in FMP with the fields you want to import. When you do import file into FMP it will display the data from the XLS and the FMP file and you can use the controler to move the name of the fields into the right positions of the input file. ONce you do this you do not have to do it again. Hope this is helpful

[Lee Smith]

You can open an Excel Spreadsheet in FileMaker. FileMaker will ask you if the first Record is data or Field Names.

HTH

Lee