October 31, 200322 yr I'm in the process of creating an application containing 5000+ fields. Basically there are 1000 fields that have 5 variations each. Does anyone know of a way to import fields into Filemaker from an external source? I'm currently using version 5.0. thnx Arny
October 31, 200322 yr It sounds to me like you have a text file? 1000 records? 5 fields per record? If this is correct, make sure that there is a return between each of the 1000 records Make sure that the fields appear in the same order in each record and that there is a tab between fields. Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5 (return) Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5 (return) Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5 (return) Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5 The (tab) & (return) are tabs and returns from the text editor. Make sure that there isn't a return before the first record nor one after the last record. In the Import menu, changing type file to "Tab-Separated Text File" and do your import. If I missed read this, either attach a sample of the data for us to see, or go into more detail about it. I prefer the former to the later. HTH Lee
Create an account or sign in to comment