Need help with importing data

T

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
 
J

John W. Vinson

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

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