Best way to Insert / Update CSV data

[Frank_Rizzo]

Currently I'm updating a database on a local PC and then uploading the complete data to the server.

The table is dropped, and all the data rebuilt via CSV.

I'd like to change that now to just upload changed / new data.

table struc: date, name, city

The way I would check if a record already exists is based on date and name. i.e. there can not be two or more records with the same date and name.

1. Read the csv file line by line.
2. If date & name already exist then delete and replace
3. If date & name do not already exist then insert

What's the best way of doing this?

[olaf]

Hallo,
you need a structure like this (don't do this if you have a real great amount of records)

build a loop with the array of your lines.

check the existens of a record with select
if exist delete the record
insert the current dat from the array element.