Need help with importing data

[thelotus99]

Hello all,

I'm working on a new database project and I'm looking for advice on
importing data on a regular basis. I want to be able to import new
data from the CSV into the main table, and have it insert new
information from duplicate records and add new records based on a
unique field that is in the CSV file. I created the initial table from
the CSV, but now when I try to import updated data, it errors out and
nothing changes.

Can anyone give some advice on the best way to accomplish this?

Thanks,
Mike

 

[Tom van Stiphout]

On Mon, 3 Mar 2008 15:06:07 -0800 (PST), "(e-mail address removed)"

My crystal ball is broke, so I couldn't see your error message. Can
you report it?

-Tom.

 

[John W. Vinson]

Can anyone give some advice on the best way to accomplish this?

Correct the error in the imported data, in your indexes, or in your code,
using the error message for guidance.