Importing tables from one FMP7 database to another

[Mike Anderson]

I realize that this may be a stupid question as a rank novice but I cannot find this answer anywhere. I have created a database from an Excel sheet where there were 456 rows(or more). I used transpose in xcel to make rows into columns, because xcel cant handle more then 254 columns? on a sheet, and I couldnt create a sheet with 456 columns (or I dont know how to as it stops at IV)> So I now have two sheets with <255 columns with the sum data between the two sheets. FM7 could handle >456 columns no problem but now I want to or have to create two tables in one database comprising the two sheets. However when I open each xls sheet, FM7 wants to create a new database and I want two or more tables in the same DB without having to type 225 fields into two tables manually. I have also seen some cool free templates that I would love to incorp into this database that I am creating. IS there a way to import tables with field data intact from other FM DBs into one master DB without having to type all the elements into each new table manually and then import the data. OR is there a program that will convert the xls sheet with 456 rows into FM7 correctly since FM7 wants to see columns as field names and not rows. Sorry for the lengthy question and hope that it makes sense. The users guide doesnt seem to help me much.

Mike

[QuinTech]

Hi, Mike. Excel (presuming you're speaking of Microsoft Excel) can handle up to 65536 rows as of 1997. Are you not able to see a row number 255?

Jerry

[Mike Anderson]

I meant columns and not rows. It stops at IV

[transpower]

Convert from Excel to a dBase file (*.dbf). Import that into FileMaker. As for incorporating other FM tables into a master FM file, use FM Migrator.

[Mike Anderson]

Nope that doesnt do it properly. gives me 455 records with one column a description and the other a data filed. When I try to add my second data values it try to go to line 456, if I import then it over writes or adds to the bottom.

[transpower]

Ok, then do it in two steps. Import set one to the FMP file. Import set two a a second FMP file, clone of the first (no records). Then import from the second FMP file to the first.