number of fields exceeds 256 when importing from a dbf file
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 |
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. |
Dave,
The maximum number of fields in a table in Access 2002 is 255. -- Earl Kiosterud www.smokeylake.com "Dave O" wrote in message oups.com... 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. |
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. |
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? |
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? |
All times are GMT +1. The time now is 03:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com