Importing a large Excel Spreadsheet with multiple rows/record
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!