Laurie Corvacho wrote: > Hi, Ralph, > > I checked the indexes on the import panel, and there is one index that > consists of the first variable length text field and the autoincrementing > field. I would have to check just to make sure that this index is not > being used for anything, but I believe it is NOT being used, and could > therefore > be deleted. However, the only thing that is ever imported into this field > is a short (up to 12-letter) code, so I wouldn't think that this is > causing the problem even though it is being used in an index, for the > following > reasons: 1) It is a short value, 2) it is only there temporarily until > the record is deleted, so it isn't there cluttering up the index > long-term, and 3) the fields and indexes in this panel have been unchanged > (none added or > changed) for literally years.
I agree that the index couldn't be the problem. You said you were able to import a large file successfully into a new empty database (at Mark's pormpting). What happens if you do this: 1. In the above database, export the data you just imported to a T-log for that single panel. 2. Copy your original problem database to a new directory (so you don't mangle the original problem database with step 3). 3. Import the T-log you created with Step 1. Does the T-log import okay? _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
