Ron, The following is pretty straightforward--let FMP auto-create the tables and populate them with data (this works in 8.5 pro--don't remember if it does in prv v's):
1) Do your various exports as .fp7. Repeat as necessary so you have a good file for each table you'll need in your new solution. Name each file with the name you'll want for your table 2) Import each file to a new table: File menu > Import Records > File--in the Import Field Mapping dialog, select "New Table"--your data will be imported and you'll auto-create a new table. This can get pretty complicated so if your solution is a big one, suggest writing out a checklist of your export/imports to use as a guide. -- Steve Steve B. Gerow FileMaker 8/7 Certified Developer President Abrazos Data Consulting, Inc. Dependable Database Development Pasadena California www.abrazosdata.com Member FileMaker Bus. Alliance > From: Ron <[EMAIL PROTECTED]> > Reply-To: FileMaker Pro Discussions <[email protected]> > Date: Thu, 5 Jul 2007 11:09:28 -0400 > To: [email protected] > Subject: Re: File Import > > Not really (shifted gears). > If I could write sql, I could do an Insert query from the original file into > my relational tables, one at a time, with multiple fields per record. > It would be a lot simpler than your option. > > However, from what I have gathered so far, I can't use sql within Filemaker > on Filemaker files, unless I use ODBC. And I do see that all of this would > be in scripts. > > Make sense? > Thanks! > Ron > > -----Original Message----- > From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On > Behalf Of Steve B. Gerow > Sent: Thursday, July 05, 2007 10:49 AM > To: [email protected] > Subject: Re: File Import > > Ron, > Don't know what you mean by this. Please amplify. FMP is not SQL. You seem > to have shifted gears from your original file conversion question. > -- > Steve > > Steve B. Gerow > FileMaker 8/7 Certified Developer > > President > Abrazos Data Consulting, Inc. > Dependable Database Development > Pasadena California > www.abrazosdata.com > Member FileMaker Bus. Alliance > >> >> Can I do an Insert query on the original file into the new relational > file? >> Then I can insert certain constants, new field contents etc. >> Using SQL seems to require an ODBC table for the source... >
