Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
doubling a number X number of times | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
making a number be text | Excel Worksheet Functions |