jamesjohnturner
New member
- Local time
- Today, 11:04
- Joined
- Aug 6, 2014
- Messages
- 2
I have a table where csv files get imported to on a daily basis. The key fields I am working with are a supply number and date. The problem I have is that sometimes the csv file will contain information that is correcting/updating information held in the table. This is creating duplicated records.
I need to either create a query to find records that have the same supply number and date or find a way of overwriting the records in the table with the new data.
I hope I have explained myself clearly, but any suggestions will be much appreciated.
I need to either create a query to find records that have the same supply number and date or find a way of overwriting the records in the table with the new data.
I hope I have explained myself clearly, but any suggestions will be much appreciated.