neadbecker
New Member
- Joined
- Jan 15, 2009
- Messages
- 43
I have a file exported from an accounting system that has no extension. The type just says "file". When I had Windows XP, I added the .txt extension (in the file name itself without opening) and was able to import the file into Access without issue. With Windows 7, it seems that this practice leads to the following error when the file is imported to Access:
"The changes you requested to this table were not successful because they would create duplicate values in the index, the primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."
I know that none of the fields of the destination table are indexed and there is no primary key. The table has not changed in between the windows conversion. In addition, I get the same error if I import into a new table.
My current work around is to open the .lis file in Excel and save it as text with no further modification to the file. When this is done, the file imports flawlessly. I would like to avoid this as the file is very large and it takes some time to open.
I've searched this out quite a bit and haven't found a very good answer, other than something related to the primary key or index (which again i do not have).
Any help or suggestion is greatly appreciated.
"The changes you requested to this table were not successful because they would create duplicate values in the index, the primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."
I know that none of the fields of the destination table are indexed and there is no primary key. The table has not changed in between the windows conversion. In addition, I get the same error if I import into a new table.
My current work around is to open the .lis file in Excel and save it as text with no further modification to the file. When this is done, the file imports flawlessly. I would like to avoid this as the file is very large and it takes some time to open.
I've searched this out quite a bit and haven't found a very good answer, other than something related to the primary key or index (which again i do not have).
Any help or suggestion is greatly appreciated.
Last edited:
