Countymnca
Technical User
Hello,
I frequently import data from Excel using transferSpreadsheet and then process it using several queries. The primary key field comes in as A-01001001 or AA01001001 and then has the - removed if it exists before the data is apphended to the main table. The problem is that occasionally, the import and processing fails...always at record 476. Once this happens, users must only import less than 476 records for it to work.
The system is in use at various locations (not interconnected) and they all end up with the problem after a period of time. All users obtain data from the same source, however their primary key fields start with different letters.
Is there something special about record 476 that is causing this problem? I find it very odd that it is always the same record number, even if the data different at different locations.
I frequently import data from Excel using transferSpreadsheet and then process it using several queries. The primary key field comes in as A-01001001 or AA01001001 and then has the - removed if it exists before the data is apphended to the main table. The problem is that occasionally, the import and processing fails...always at record 476. Once this happens, users must only import less than 476 records for it to work.
The system is in use at various locations (not interconnected) and they all end up with the problem after a period of time. All users obtain data from the same source, however their primary key fields start with different letters.
Is there something special about record 476 that is causing this problem? I find it very odd that it is always the same record number, even if the data different at different locations.