number of fields exceeds 256 when importing from a dbf file

[Guest]

Hey evryone,

I'm having a small problem with importing some old data from a FileMaker Pro
database. According to what I found out in the groups archive the best bet is
to convert it to a dbf file and then import it. However, I the number of
fields in the dbf file exceeds 256, so the import wizard truncates the import
at field number 256.

I would now want to spread the data over two sheets. However, in the process
of converting it to a dbf, quite a few of the field names get truncated and
therefore have the same name, so I can't use SQL to retrieve them. My
question is: what is my next best bet?

Thanks in adavnce for any and all help

Chris

 

[Dave O]

One way- maybe? Import from Filemaker to MS Access, and then divvy up
the resulting "master" table into one table that has 256 columns and a
second table that holds the remaining columns.

 

[Earl Kiosterud]

Dave,

The maximum number of fields in a table in Access 2002 is 255.

 

[Guest]

The maximum number of fields in a table in Access 2002 is 255.
--

And even if that did work, the fields by the same name prevent the importing
into Access. I've tried that.
Oh, and whatever genius programmed the FileMaker db locked me from viewing
the table schema, so I more or less _have_ to rely on a dbf file.

 

[Dave O]

Does Filemaker allow you to export to text? Can you write code for
Filemaker as you can for Access, and write your own export routine?
Got any old copies of dBase III+ laying around?

 

[Dave O]

Does Filemaker allow you to export to text? Can you write code for
Filemaker as you can for Access, and write your own export routine?
Got any old copies of dBase III+ laying around?