Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!eu.feeder.erje.net!news.stack.nl!aioe.org!.POSTED!not-for-mail From: Helpful Harry Newsgroups: comp.databases.filemaker Subject: Re: Matching Names Date: Wed, 05 Mar 2014 13:28:05 +1300 Organization: Aioe.org NNTP Server Lines: 32 Message-ID: <050320141328050735%HelpfulHarry@BusyWorking.com> References: <030320141845352040%karl@hotmail.com> NNTP-Posting-Host: qV98TBNbuDUdmlhp1kZoXA.user.speranza.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@aioe.org User-Agent: Thoth/1.5.4 (Carbon/OS X) X-Notice: Filtered by postfilter v. 0.8.2 Xref: csiph.com comp.databases.filemaker:1738 In article <030320141845352040%karl@hotmail.com>, KRL wrote: > > I have a large DB of over 60K records. I have another of about 2300. > There are 325 records in the latter that I want to "export" to the > larger DB file. > > I've done this a hundred times - no problem. Now, when I go through > the routine, it tells me in the "Import Summary" > Total records added / updated 325 > Total records skipped due to errors: 325 > Total fields skipped due to errors: 0 > Table created > > And no files are transferred. > > When I try and save the exported file as tab-separated and begin the > process, it won't give me "matching names" highlighted so importing > would be NOT a good thing. > > Any help here? You don't say which version of FileMaker or computer operating system you're using. 60,000 records is quite a lot and depending on what data is being stored, maybe you're hitting the filesize limitations of one or both. You can always match import fields manually. It would be a bit painful if there are a lot of fields, but FileMaker normally remembers the previous order, so you may only have to do it once. Helpful Harry :o)