AnsweredAssumed Answered

Importing a large Excel Spreadsheet with multiple rows/record

Question asked by Foofer19 on Mar 10, 2011
Latest reply on Mar 10, 2011 by philmodjunk

Title

Importing a large Excel Spreadsheet with multiple rows/record

Post

I'm trying to import a large (32,900 rows x 12 columns) Excel spreadsheet that contains 21,600 records, many with multiple rows for each record.  When I try to do a simple import, each row shows up as a single record, not as a repeating field within each record. Although most of the fields (columns) will contain only one to 10 words, I have to narrow down the number of records through a boolean search, so that I can then import the last field ("Description"), which may contain several pages of single-spaced text.  This is not something I can easily go through record by record to correct the number of fields.  Also, this database is law-enforcement sensitive, so it can't be posted/displayed or otherwise shared.

Although I've used filemaker Pro before, it was waaay back in version 5.

Any help at all would be massively appreciated!

Outcomes