Hi all,
I maintain a small Access 2000 database for one region of my company that imports data extracts from several systems from which to produce local management reports.
The extracts are all Excel files and I've been using Transferspreadsheet to import the files into temporary tables. This database has been working fine for over a year now.
I've come back from leave this week to find that one of the databases the extracts come from has been amended so that some of the field names in the extracts are different and now I'm having problems importing these extracts.
I've done the obvious thing of changing the field names in my database to match the new ones in the extracts (there's no chance of getting the source database to revert to the original file names unfortunately) and I've tried just doing an import via the file menu to a new table, deleting records and then importing using Transferspreadsheet into that table but I get the same issue both ways.
The error message I'm getting is "... was unable to append all the data to the table.
The contents of fields in 0 record(s) were deleted, and 0 record(s) were lost due to key violations.
...
Do you want to proceed anyway?"
If I click yes then data imports but there's around a thousand records missing.
As far as I can tell from going over the new extracts and comparing them to the extracts from before the source database changed there are no differences in the record structure or the format of the columns.
I'm stumped as to why this has now stopped working and why I can't get it working again.
I maintain a small Access 2000 database for one region of my company that imports data extracts from several systems from which to produce local management reports.
The extracts are all Excel files and I've been using Transferspreadsheet to import the files into temporary tables. This database has been working fine for over a year now.
I've come back from leave this week to find that one of the databases the extracts come from has been amended so that some of the field names in the extracts are different and now I'm having problems importing these extracts.
I've done the obvious thing of changing the field names in my database to match the new ones in the extracts (there's no chance of getting the source database to revert to the original file names unfortunately) and I've tried just doing an import via the file menu to a new table, deleting records and then importing using Transferspreadsheet into that table but I get the same issue both ways.
The error message I'm getting is "... was unable to append all the data to the table.
The contents of fields in 0 record(s) were deleted, and 0 record(s) were lost due to key violations.
...
Do you want to proceed anyway?"
If I click yes then data imports but there's around a thousand records missing.
As far as I can tell from going over the new extracts and comparing them to the extracts from before the source database changed there are no differences in the record structure or the format of the columns.
I'm stumped as to why this has now stopped working and why I can't get it working again.
