AnsweredAssumed Answered

Importing excel spreadsheet to create database

Question asked by business on Sep 25, 2009
Latest reply on Sep 25, 2009 by philmodjunk

Title

Importing excel spreadsheet to create database

Post

I am using file maker pro 10 on a Mac OS X version 10.4.11 and want to create a data base in filemaker from an existing excel spreadsheet (xlsx). 

My trouble is, I have arranged my data on my excel spreadsheet by headings down the page in the first and second columns and not across the top row. So I do not want to use the First Row Option - I almost want to use a First/Second Column Option. Is there such a thing?

 

I want to be able to export 'a template of headings and questions (like a form)' from excel to filemaker. As the excel file I have will be distributed to others at work to be used as a form and then I want to be able to import their answers into filemaker. 

 

Is there something I can do to overcome this? 

 

Thanks

 

 

Outcomes