![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have been trying to import some database into Filemaker that are somewhat large, 300,000 to 1,000,000 records, each record having 7 fields. I can export the data from the program I am getting the data from and upon inspection I find no problems with it. After opening the database in Filemaker the first field in the first 100 records or so are fine, after that the first fields of the records are filled with "???". This field is a number, the other fields which are text come thru just fine. Exporting from the data program in DBF or CSV seems to make no difference...the data is fine till Filemaker gets it. |
#3
| |||
| |||
|
|
Eric Cartman <timmyis (AT) invalid (DOT) com> wrote: I have been trying to import some database into Filemaker that are somewhat large, 300,000 to 1,000,000 records, each record having 7 fields. I can export the data from the program I am getting the data from and upon inspection I find no problems with it. After opening the database in Filemaker the first field in the first 100 records or so are fine, after that the first fields of the records are filled with "???". This field is a number, the other fields which are text come thru just fine. Exporting from the data program in DBF or CSV seems to make no difference...the data is fine till Filemaker gets it. Make the number fields a little bit bigger in layout mode |
#4
| |||
| |||
|
|
Thanx Henk! That was the problem....please excuse me while I quietly walk away with my head hanging down! In article <030820030747384031%timmyis (AT) invalid (DOT) com>, Eric Cartman timmyis (AT) invalid (DOT) com> wrote: Will do Henk B...If that is the only reason it is filled with ??? I am going to feel like a dork! |
#5
| |||
| |||
|
|
Eric Cartman wrote: Thanx Henk! That was the problem....please excuse me while I quietly walk away with my head hanging down! In article <030820030747384031%timmyis (AT) invalid (DOT) com>, Eric Cartman timmyis (AT) invalid (DOT) com> wrote: Will do Henk B...If that is the only reason it is filled with ??? I am going to feel like a dork! Knowing what the technical meaning for dork is, I wouldn't be too unhappy... But yes, there are many times when the simplest answer is the right one, and people feel silly :-) Cheers Webko |
![]() |
| Thread Tools | |
| Display Modes | |
| |